SSMS Tools For SQL Server 2008

SSMS Tools Pack is a must have add-in for SQL Server Management Studio. It comes packed with a great set of features which as the author says on his site “…were missing from Management Studio”. Here is run down of three features I use most.

Text Format

If SSMS Tools Pack had only one feature and it was text formatting I’d still have praise for the tool. In the past I have used tricks such as switching to query designer view or an online SQL formatting service to format my SQL. With SSMS Tools Pack this can easily be done by pressing Ctrl+K and Ctrl+G. This feature is also configurable and you can enable/ disable keywords.

Generate Insert Statements

Insert Statements can be easily generated for data in your tables. This comes in handy when you want to script your data and maybe run it on another database. Generating Insert Statements is easily done by right clicking on the table –> SSMS Tools –> Generate Insert Statements.

SQL Query Execution History

While working with databases I can at times write a lot of queries. I usually end up commenting many in Query editor just to keep them around. With SQL Query Execution History I don’t bother. I always get a nice history of all queries I have executed in the order of execution.

Other than its features, the thing I like most about SSMS Tools Pack is that it is a light weight add-in which does not mess up your environment. So if you spend a lot or any time writing SQL then SSMS Tools Pack is worth a look.

Link to Download SSMS Tools Pack.