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

<< Back To Basics: What is a Clustered and a Non-Clustered index (plus an appealing visual prop) | Home | .Net: Passing user data with Exception back to the caller method >>

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.

Print | posted on Thursday, September 20, 2007 3:16 PM

Feedback

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

# 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

Post Comment

Title
Name
Email
Url
Comment
Remember Me?
Please add 6 and 4 and type the answer here: Enter the code shown above:

I want some Moore

My Links

SQLTeam.com Links

News

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff