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.
- Export current GRID to Excel files (without re-execution!)
- Format selected TSQL code with internal SQL Server parser
- Quick access to code templates
- 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.