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

Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

After a long while I've finally managed to create a release version. I've also added some cool new features.

It is completely free and has no expiration date like the prior beta versions.

I've also changed the RSS feed to Feedburner to which you can subscribe to at: http://feeds.feedburner.com/SsmsToolsPack

If you're subscribed to the old feed please change it.

 

In SSMS Tools Pack 1.0  you can find these features:

 

- Uppercase/Lowercase keywords:

          Set all keywords to uppercase or lowercase letters. Custom keywords can be added.

- Run one script on multiple databases:

          Run selected or full window text on selected databases on the currently connected server.

- Copy execution plan bitmaps to clipboard:

          Copy selected or all execution plans to a bitmap that is saved on the clipboard.

- Search Results in Grid Mode and Execution Plans:

          Find all occurrences of your search string in the execution plans or in the results in datagrid mode.

- Generate Insert statements for a single table, the whole database or current resultsets in grids:

          Generate insert statement from your data.

- Query Execution History (Soft Source Control)

           Save all executed queries to file or database and easily find them.

- Text document Regions and Debug sections

           Add Regions and Debug section in your scripts to ease development experience.

- Running custom scripts from Object explorer's Context menu

           Speedy execution of custom scripts from Object Explorer's context menus.

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

           Generate Customizable CRUD stored procedures for all tables in your database.

- New query template:

           Create a template that is shown when creating a new query window.

 

Currently supported SQL Server Management Studio versions are:

SQL Server Management Studio 2008 CTP

SQL Server Management Studio 2005

SQL Server Management Studio 2005 Express

 

Hope you enjoy it!

And if you're feeling extra generous there's always PayPal. :)

 

kick it on DotNetKicks.com 

 

Print | posted on Thursday, May 08, 2008 10:35 AM | Filed Under [ SQL Server SSMS Tools Pack ]

Feedback

Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

Cool....i will certainly try it....
5/9/2008 6:35 PM | Bojan Vrhovnik
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!


The addin doesn't work for me, I get the following message when starting SSMS:

"The Add-in 'SQL Server Management Studio Tools Pack' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: <Unknown Error>
Error number: 80040154"

I'm using SSMS 2005 on Windows Vista Business (swedish).
5/19/2008 12:52 PM | Johan
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

hi,
vista has some quirks that sometimes lead to load failure. try installing it by running exe and not msi, install it for all users and install it under admin account.

Hope this helps.
5/19/2008 12:56 PM | Mladen
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

I installed the sql management studio 2005 add-in. I added a region to the code, clicked on the #--endregion-- section and my mouse started like it was saving a file but just locked up the environment. I closed the app because it was not responding and when I attempted to open the project again, the environment locked up. Had to uninstall the add-in.

Thanks
Royal
5/19/2008 6:35 PM | Royal Hale
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

hi,
is there any chance you could send me the script that caused this?
5/19/2008 6:36 PM | Mladen
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

The SSMS tools feeback page isn't working. I get a "undeliverable" e-mail sent to me saying that it doesn't know the e-mail host (The following recipient(s) cannot be reached:

support@ssmstoolspack.com on 6/2/2008 3:37 PM
You do not have permission to send to this recipient. For assistance, contact your system administrator.
<HSV04 #5.7.1 smtp;550 5.7.1 Client host rejected: cannot find your hostname, [91.185.197.130]>)

In any case, the Format Keywords option is a bit annoying since it formats all comments as well.

Also, the default setup includes the word VALUE. If you're doing xml work, uppercasing this keyword is invalid so using the format keywords option straight out of the box actually breaks the SQL.
6/2/2008 9:43 PM | Eric
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

hmm... i got the email just fine. probably some problems at the hosting company. thanx for letting me know.

yes i know that it formats the comments as well.
i guess you can remove the value and any other keyword you do not wish to format from the list.

i'm planing to improve this in the next release.
thanx.
6/2/2008 9:52 PM | Mladen
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

Awesome, the insert statements feature is definately a time saver. Thanks!
6/20/2008 8:08 PM | Keelio Software
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

Very nice set of tools that will come in very handy. A few suggestions for possible enhancements:
* Ability to display the <Text> of the --#region <Text> in the collapsed section in the IDE instead of the ellipses below the region
* Some way to remove the brackets ([]) around the field names from the |columnList|, |insertColumnList|, etc fields which are generated. I know this is done to resolve the issue of fields which contain the same name as known keywords. In my cause I've removed the brackets from almost everything in the templates which explicitly use them but there is no option in the mass generated field lists. This just makes the code a little more readable
* Include a newline character after the |columnList|, |inserColumnList|, etc fields so each field is on it's own line similar to the way the |inputParams| are generated
* For some reason I'm still getting two SSMS Tools context menu options

All in all very nice. Keep up the good work.
7/30/2008 10:57 PM | TechnoDex
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

It worked fine with SQL Server 2005 and windows Vista Businness. I downloaded SQL Server 2008 Dev and installed SSMS Tool Pack for SQL Server 2008 CTP. When SQL Management stars it shows :

"The Add-in 'SQL Server Management Studio Tools Pack' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.

Error Message: <Unknown Error>
Error number: 80040154"

I installed it running SETUP.EXE as administrator. Doed anyone know how to solve this problem?
9/3/2008 1:03 PM | Claudio
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

I am having the same problem as Claudio - Tools Pack will not install on RTM - 10.0.1600
Any updates?
9/8/2008 11:04 AM | Howard Diesel
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

Very nice! Is there a way to remove a region once it's created?
Thanks.
11/7/2008 6:47 PM | Steve W
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

unfortunately not at the moment.
you'll have to close and reopen the window.
11/7/2008 7:02 PM | Mladen
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

How do I add my personal script into Custom script in SSMS Tools ?
10/20/2009 5:28 PM | Hemesh
Gravatar

# re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out!

you can do that in Custom Script Options.
10/20/2009 5:51 PM | Mladen
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET