Warning

Repository Archived

This repository is no longer active, as we have moved to a newer version. For the latest updates and features, please visit the new repository at Axial SQL Tools. We encourage you to check out the new version for the most up-to-date tools and improvements.

---

SQL Server Management Studio 2018 Productivity Tool (Addin)

Work in progress... I had to make it as an "ugly" toolbox window because I couldn't figure out how to make a dynamic menu in a toolbar.

• Format selected TSQL code with internal SQL Server parser or Poor Man's SQL Formatter
• Quick access to code templates

.NET 4.7.2 is required.

To install the addin unpack files from the most recent release into C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions folder.

(OLD) Simple addin for SQL Server Management Studio 2008-2014 that helps with:

• Export current GRID to Excel files (without re-execution!)
• Format selected TSQL code with internal SQL Server parser
• Quick access to code templates

Installation:

• Unpack files into any folder
• Modify SSMSTool.AddIn file - change path to SSMSTool.dll file
• Copy SSMSTool.AddIn file to C:\ProgramData\Application Data\Microsoft\MSEnvShared\Addins folder (create it if not exists)
• If error 80131515 occures - add <loadFromRemoteSources enabled="true" /> into "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe.config" right after <runtime>

SQL Server Management Studio 2016+ is not supported.