Refer to the following screenshot:
In the previous versions of SQL Server Management Studio, it was working perfectly. I am using Windows 10 on a desktop PC.
Appreciate any help for this :)
Poor mans T-SQL formatting add-in "Format T-SQL Code" option disabled in SQL Server Management Studio v18.5
Viewed 8891
2 Answers
For the versions of the plugin that supports SMSS 2014-2018, PoorMan's T-SQL Formatter requires the Visual Studio 2015 Isolated Shell installed in order to work. It can be downloaded from here. After installing it, the option will be made available.
Edit ssms.exe.config C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE
In <assemblyBinding> Add
<dependentAssembly>
<assemblyIdentity name="Microsoft.VisualStudio.Shell.12.0" publicKeyToken="b03f5f7f11d50a3a" culture="neutral"/>
<bindingRedirect oldVersion="2.0.0.0-15.0.0.0" newVersion="15.0.0.0"/>
</dependentAssembly>
Related