I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

SSMS Tools Pack is an Add-In (Add-On) for Microsoft SQL Server Management Studio 2005 and

Microsoft SQL Server Management Studio Express 2005.

It contains a few upgrades to the IDE that I thought were missing from Management Studio.


These are:

 - Query Execution History (Soft Source Control): saves every query text you execute in a file or in a database

 - Text document Collapsable Regions and Debug sections: regions and debug section known from Visual Studio which are missing in SSMS

 - New query template: set the template that will open when you open a new query

 - CRUD (Create, Read, Update, Delete) stored procedure generation: templated CRUD stored procedure generation

 - Running custom scripts from Object Explorer's Context menu: Add custom scripts you can execute from the object explorer context menu

 

you can find it on www.SsmsToolsPack.com

 

Any suggestions for improvements are welcomed.

kick it on DotNetKicks.com

Print | posted on Thursday, September 20, 2007 3:16 PM | Filed Under [ SQL Server SSMS Tools Pack ]

Feedback

Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Very nice tool!! These life-saving features will definitly come in handy.
One suggestion, on the query history dialog maybe have an option to send the query text to a new query window in SSMS?

Also, I have compiled a list of exceptions that I have experienced when using this add-in. You can find it here: http://developer.franklinrau.com/uploads/ssms_tools_exceptions.txt.

One other error thrown was when creating a database snapshot from the context menu it gives:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'AS'.


Nice Job.
9/20/2007 6:00 PM | Franklin Rau
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

hey thanx for that!
what is the script that gets executed when you create a snapshot?
9/20/2007 6:03 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

CREATE DATABASE ldx_ss ON ( NAME = ldx, FILENAME = 'c:\ldx_ss.ss' ) AS SNAPSHOT OF ldx;
9/20/2007 6:21 PM | Franklin Rau
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

so in this script where is the error?
because this parese fine for me.
9/20/2007 6:31 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Nevermind... leave it to a rookie to try to create a snapshot on a 2000 instance. Sorry!
9/20/2007 6:56 PM | Franklin Rau
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Will this tool be free, when released?
9/21/2007 9:40 AM | Bojan Vrhovnik
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

that's my plan for now
9/21/2007 9:47 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Very handy tool, congratulations on a great work!

The Ctrl+Shift+M shortcut interferes with Template Parameter dialog, except that little annoyance I'm very pleased!

keep it up
9/25/2007 10:14 AM | oggelito
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

yeah i noticed that... i plan to add configurable shortcuts in the next version.
9/25/2007 11:52 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

It doesn't work in Katmai
10/3/2007 3:16 PM | dfrr
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

no it doesn't.
and it won't until katmai gets out.
10/3/2007 3:21 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

How do this stand out compared to yours?
http://entropia-online.blogspot.com/2007/08/free-script-to-create-crud-procedures.html
10/9/2007 10:00 AM | Peter Larsson
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

you tell me :)
10/9/2007 11:02 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

I can't. I am using SQL Server 2008 :-)
10/9/2007 11:16 AM | Peter Larsson
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

oh right... :))

well mine is fully templated as well. so you can do whatever you want to it.
10/9/2007 11:21 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Hi guys :)

I just tested Mladen's CRUD generator. A few things I noticed:

Transactions used everywhere, which might significantly affect performance. Also, why wrap things in a transaction and then not offer a rollback in case something goes wrong?

What I can see my script doing better is it allows for user-defined types, and it allows for the option of excluding certain often repeated columns.

Other than that, it's up to the programmer to decide which flavour of the procedures he/she prefers, I guess :)

(I did notice that in the right-click menu, SSMS tools shows up twice for me. As do the options under it...

I.e. right-click a table

SSMSTools -> Run custom scripts
-> Generate CRUD
<seperator>
SSMSTools -> Run custom scripts
-> Generate CRUD
<seperator>

10/9/2007 7:04 PM | Peter Schmitz
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

hey peter!

well i put the transactions there just for the template. you're of course welcome to change it. that's why it's there for :))

userdefined types, huh? haven't thought of them at all! thanx for reminding me!

fo items appearing twice just restore ssms. i've fixed the problem (hopefully :)) and will put the fix in the next version.
10/9/2007 10:21 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

The ability to purge history automatically would be nice.

Custom Scripts are really nice, but they sometimes show up when they shouldn't and will crash.

Add Remove Buttons/configure menu options would be nice.

When a region is created, but then removed after the fact it stays until you exit script and come back in.
Expand all/collapse all regions would be nice.

In general quite nice.
10/10/2007 10:07 PM | Bob Fazio
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

> The ability to purge history automatically would be nice.

purge all history? hmm...
well you can just delete the files/directirues in the history folder you want to remove.


> Custom Scripts are really nice, but they sometimes show up when they shouldn't and
> will crash.

i know of this bug and i'm in the process of fixing it


> Add Remove Buttons/configure menu options would be nice.

i'm not quite sure what you mean by that


> When a region is created, but then removed after the fact it stays until you exit script
> and come back in.

will look into this. thanx!


> Expand all/collapse all regions would be nice.

I tried to implement this but haven't found a way to do it. yet! :)


> In general quite nice.

Thanx :)
10/10/2007 10:14 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Is it correct that the query is saved twice with different execution times in the query history?
10/17/2007 1:29 PM | Henk
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

this shouldn't be happening
10/17/2007 1:36 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

hi i a doing a course in sql server 2005 i am having a 180 day triel sw for sql i.e SSMS BUT IT IS EXPIRED WAT TO DO NOW ...
7/5/2008 11:07 PM | ALEEM
Gravatar

# re: SSMS Tools Pack support for SQL Sever 2008 does not work

Support for SQL Server 2008 does not work correctly.

Just for information.

Thanks for the tool in 2005, though
8/14/2008 3:54 PM | kuklei
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

yes i know. i haven't had time to implement it for the RTM of sql server 2008.
8/14/2008 3:58 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Great product been using on my home machine using Managment Studio Express 2005 with no problems just installed Sql 2005 Developer on my work machine and also installed SSMS Tool Pack upon loading Mansagment Studio I get the following error.

System.MissingMethodException: Method not found: 'System.Windows.Forms.ToolStripItem[] Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.IWinformsMenuHandler.GetMenuItems()'.
at az.i()
at SSMSToolsPack.Connect.OnConnection(Object application, ext_ConnectMode connectMode, Object addInInst, Array& custom)

11/21/2008 1:35 PM | Burrows
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

You are the man!!!!!!!!!!!

The add-on is simply awesome. Thank you very much

2/4/2009 5:05 PM | Hari
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

I am really looking for a "favorites" feature where I can pick a template in existing window.

You support the custom template but:
1) it tries to execute it, I currently have to break the sql so that it fails to execute and I can update the statements with criteria
2) opens up a new query window

I would really love to right click in my existing window and pick a favorite query

To improve your existing template support it would be really nice to:
1) have a template variable example: select * from orders where orderid = <orderid> and it would populate that <orderid> with whatever is in the clipboard
2) have an option to not automatically run when being chosen.

-Markus

3/30/2009 10:57 PM | Markus
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Hi,
i GET THE FOLLOWING ERROR WHEN TRYING TO OPEN SSMSEE.EXE (EXPRESS EDDITION):

System.MissingMethodException: Method not found: 'System.Windows.Forms.ToolStripItem[] Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.IWinformsMenuHandler.GetMenuItems()'.
at ab..ctor(DTExtensiblity2Class A_0)
at SSMSToolsPackBase.DTExtensiblity2Class.a(Boolean A_0)
at SSMSToolsPack.Connect.OnConnection(Object application, ext_ConnectMode connectMode, Object addInInst, Array& custom)
Is there a fix or work-around?
Thx
6/14/2009 12:54 AM | VLAD
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

You need to install SP2 for SSMS. I've stopped supporting pre SP2 versions with ssms tools pack version 1.1.

Have fun!
6/14/2009 1:36 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Here is another useful add-on for SQL Server Management Studio if you often reformat sql from others.

SQL Pretty Printer Add-On for SSMS
http://www.dpriver.com/sqlpp/ssmsaddin.html
7/31/2009 5:58 AM | James
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

hi,

i even face above error having properly installed ssms 2005 enterprise with SP 2.

(Method not found: 'System.Windows.Forms.ToolStripItem[] Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.IWinformsMenuHandler.GetMenuItems()'.)

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
shows
9.00.3294.00 SP2 Enterprise Edition (64-bit)

any suggests?
8/10/2009 11:34 AM | gereon
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

@gereon:
you need sp2 or higher for SSMS (client tools) not sql server.
SERVERPROPERTY('productversion') returns the SP of the server not SSMS.
8/10/2009 11:38 AM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

thx. thats it....

just playing around with "region" feature. this is great feature -for me- 'cos were having very large sp's...
but it doesnt work like beeing used to in VS. so just typing "--#region blah" and "--#endregion blah" won`t work. just marking the area to be regionalised and then choose "create region" from menu works.

whats the trick?
8/11/2009 7:01 PM | gereon
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

you have to choose parse regions from the context menu in the editor.
i might add the auto recognize region in the future though.
8/16/2009 3:28 PM | Mladen
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

You should consider making this a codeplex opensource project. I was going to make another function that I think SQL is lacking and make it its own plug in, but I'd rather add to your project - if it were opensource.
12/22/2009 7:16 PM | Dan
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

Looks nice but I wonder about the wisdom of generating Stored Procs to replace single statement DML. Eg: p_InsertRow, p_UpdateRow, p_DeleteRow, p_SelectRow. To me the value of a SP is encapsulation of the interface. Thus I prefer people to create SP's that do a complete unit of work relevant to an application. eg: p_AddInvoice may insert rows in both the InvoiceHeader & InvoiceDetails tables & possibly Update the Customer table or enter Audit info. OR p_ShowEmployeeTree to retrieve a hierarchy filtered in some way, perhaps User_ID.

Sure I'd prefer people used a SP than use TSQL directly but rarely is it optimum design to flood the DB schema with 4 procs per table.

That said, Thanks for sharing your work. Clearly you put a lot of work into this tool. I do like the fact that some of your syntax is more efficient than SSMS. ie DROP OBJECT using OBJECT_ID() function correctly. For your INSERT & SELECT example, please consider using the OUTPUT clause of the INSERT statement, as it is much more efficient.
9/21/2010 7:31 AM | David Lean
Gravatar

# re: SSMS Tools Pack - an add-in for SQL Management Studio 2005 is out (beta stage)

@David:
The STP creates simple CRUD that you need fast. if you have to modify the procs you can do that. Template is also customizable. In any case you have to do some work my hand and there's no tool that will automate everything.

As for the output SQL Server 2000 didn't have that and still a lot of people use it.
So i prefer not to be version specific.
9/22/2010 2:02 PM | mladenp
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET