Search code examples
ssms-18

Poor mans T-SQL formatting add-in "Format T-SQL Code" option disabled in SQL Server Management Studio v18.5


Refer to the following screenshot:

enter image description here

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 :)


Solution

  • 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>