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.
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. :)
|
|
Legacy Comments
|
Bojan Vrhovnik
2008-05-09 |
re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out! Cool....i will certainly try it.... |
|
Johan
2008-05-19 |
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). |
|
Mladen
2008-05-19 |
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. |
|
Royal Hale
2008-05-19 |
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 |
|
Mladen
2008-05-19 |
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? |
|
Eric
2008-06-02 |
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. |
|
Mladen
2008-06-02 |
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. |
|
Keelio Software
2008-06-20 |
re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out! Awesome, the insert statements feature is definately a time saver. Thanks! |
|
TechnoDex
2008-07-30 |
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. |
|
Claudio
2008-09-03 |
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? |
|
Howard Diesel
2008-09-08 |
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? |
|
Steve W
2008-11-07 |
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. |
|
Mladen
2008-11-07 |
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. |
|
Hemesh
2009-10-20 |
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 ? |
|
Mladen
2009-10-20 |
re: Ease your SSMS experience: SSMS Tools PACK 1.0 is out! you can do that in Custom Script Options. |