/ssms-addin

SQL Server Management Studio 2018 Productivity Tool

Primary LanguageTSQLGNU General Public License v3.0GPL-3.0

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.