SSMS Tools Pack
Beta support for SSMS 2017 RC1
Beta support for SSMS 17 RC1. Due to beta status this might have various bugs.
Since SSMS 17 RC1 has just been released and is not recommended for production use the SSMS Tools Pack
for it might run into various issues as well. They will be worked out as the SSMS 17 gets more stable.
SQL Editor Plus
New Run At...
Full support for SSMS 2016 RTM which came out June 1st 2016.
This new release brings the following feature improvements:
SQL Editor Plus
Renamed tabs get the custom name stored and properly restored in the SQL History's Tab Session.
Global Replacement Texts
Now you can have nested replacement texts that are properly evaluated up to 10 levels deep.
Insert Statements Generator
It can now also script views. Added an option to...
This new release brings the following new features and feature improvements:
Export to Excel:
Properly export result sets, one or multiple tables or the whole database to Excel files.
This feature doesn't need Excel installed to work. It correctly converts SQL Server data types
to Excel data types, supports exporting unlimited table rows and creates a valid XLSX file.
Window Connection Coloring:
Custom text can now be set...
This new feature brings the following improvements:
Support for SSMS 2016 CTP 2.3 and up:
With each new SSMS 2016 CTP the compatibility might break. Future updates will come as soon as possible.
Search Database/Table Data:
Completely new Search dialog with the ability to filter on table names, column names and column data type groups.
The new feature is called Global Replacement Texts. It gives you the ability to add custom replacement texts to your scripts in four different features. Licensing now gives you the ability to upgrade your existing license from the previous major version. This upgrade path is around 30% cheaper than buying a completely new license. SQL Editor Plus has been extended with 2 new functionalities: - Rename Window Tab by right clicking on...
With version 3.0 the SSMS 2014 is fully supported. Since this is a new major version you'll eventually need a new license. Please check the EULA to see when. As a thank you for your patience with this release, everyone that bought the SSMS Tools Pack after April 1st, the release date of SQL Server 2014, will receive a free upgrade. You won't have to do anything for this to take effect. First thing you'll notice is that the UI has been completely changed....
This version adds support for SQL Server 2012 RC0 and fixes a few bugs with SQL History. Because of the support for regions in SSMS 2012 the regions and debug sections feature has been removed from SSMS Tools Pack for SQL Server 2012. The feature is still available for previous SSMS versions. In other news SSMS Tools Pack has won the SQL Magazine bronze award for best free tool of 2011. You can view all the details at the SQL Server Magazine Award page. Thanx to all the people who...
What better way to end the summer and start those productive autumn days ahead than with a fresh new version of the SSMS Tools Pack.
This is a big release with two new features that are huge productivity boosters.
First new feature are Tab Sessions. Every SQL tab you open is saved every N (default 2) minutes and is stored in a session. This works similar to internet browser sessions. Once you reopen SSMS you can restores your last session with a click of a button. You even get every window connected to the server it was previously connected to. The Tab...
To end the year on a good note this release adds support for SQL Server 2011 (Denali) CTP1 and fixes a few bugs.
Because of the new SSMS shell in SQL 2011 CTP1 the SSMS Tools Pack 1.9.4 doesn't have regions and debug sections functionality for now.
The fixed bugs are:
A bug that prevented to create insert statements for a database
A bug that didn't script commas as decimal points correctly for non US settings.
A bug with searching through grid results.
A threading bug...
This release adds a great new feature and fixes a few bugs.
The new feature called Window Content History saves the whole text in all all opened SQL windows every N minutes with the default being 30 minutes. This feature fixes the shortcoming of the Query Execution History which is saved only when the query is run. If you're working on a large script and never execute it, the existing Query Execution History wouldn't save it. By contrast the Window Content History saves everything in a .sql file so you can even open it in your SSMS. The Query Execution History...
This is a release that fixes all known bugs. If you encounter any new ones don’t hesitate to report them. :)
The main feature list hasn’t changed.
A few improvements have been made though:
Save SQL Snippets to HTML and/or print them directly from SSMS.
In Window Connection Coloring the server names can now be regular expressions giving you the ability to color multiple servers with the same color.
Here’s a blog from David Levy (Blog|Twitter) about the new window connection coloring using regular expression and why is it really useful to him. Thanx for kind words Dave.
You can download the new version 1.9 here.
This is a release that fixes all known major bugs and most of the minor ones.
The main feature list hasn’t changed.
The only addition is the ability to export and import only SQL snippets.
Before you could only export/import all settings which included the snippets.
You can download the new version here.
Due to a bug i haven’t anticipated, a whole load of users with non English SSMS couldn’t install the latest SSMS Tools Pack 1.7.
The SSMS Tools Pack 18.104.22.168 fixes this as well as 1 other major bug that was reported and 3 smaller ones.
The feature list hasn’t changed.
You can simply reinstall 22.214.171.124 over the 126.96.36.199.
If you’re still on 1.5 or less then you’ll have to manually uninstall it and install 188.8.131.52.
You can download the new version here.
Hopefully this will bring back joy to everyone :)
Ladies and gentlemen, boys and girls, the STP is back to rock your world!
The new feature is SQL Snippets to speed up your development.
This new version brings one completely new option, full GUI redesign, completely rewritten installer, improved error handling and reporting, bug fixes and old features improvements.
Type in the assigned shortcut, press enter or tab and get the snippet you need.
It's quick, clean and saves time!
Some of more visible improved features include:
Completely new installer using the powerful Windows Installer XML (WiX) toolset. Now there’s only one MSI installer file for...
This new version brings one completely new feature and a few improved old ones.
The new feature is Window Connection Coloring.
It includes a colored strip indicator that can be docked to any side of the window.
Improved features include:
Search Table or Database Data
Uppercase/Lowercase keywords and Proper Case Database Object Names
Sending feedback directly from SSMS.
Import and Export options.
With this new version you can use it for SQL Server Management Studio 2008 and SQL Server Management Studio 2008 Express.
I've added a new feature to Search through the Database data. There are times when you'd like to find some value but can't remember in which table it is.
Also the SQL Query History Log Viewer has been remodeled. I'm open to suggestions on how to improve it further.
You can also have the SSMS Tools Pack installed for both SSMS 2005 and SSMS 2008 on the same machine, however they don't share the same settings.
I would also like to...
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...
Just as the title says :)
You can read the article here.
Thanx to Kevin Kline for publishing it!
I've released a new version of the add-in.
Most of the reported bugs are fixed and I've added two new main functionalities:
- Search Results in Grid Mode and through Execution Plans
- Generate Insert statements for a single table, the whole database or current resultsets (yes all of them) in grids
Insert statement support scripting binary data up to 5 Mb from image and varbinary(max) columns
Minor changes include customizable shortcuts and the ability to move the menu between tools submenu and main menu bar.
You can find it on www.SsmsToolsPack.com or subscribe to the RSS feed to get notified of the new changes...
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.
- 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:...
UPDATE: This is now a part of a larger SSMS Add-In called SSMS Tools Pack
I thought I'd post something special as the last post of this year and i was thinking about what it would be.
Fellow SqlTeamer Rockmoose said he'd like to have an add-in for SSMS that would genereate basic
CRUD (Create - Insert, Read - Select, Update, Delete) stored procedures for a table.
And he'd like to have it on the context (right-mouse-click) menu of the table in Object Explorer in SSMS.
It sounded like a very cool little project and with the help of this excellent post about SSMS add-ins
I've decided to...