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

Question

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

It's probably worth to mention in the body of the question that you are using [Poor Man's T-SQL Formatter](https://stackoverflow.com/a/7197517/11683). — GSerg, Aug 08 '20 at 09:15
I found the answer: Need to download and install Visual studio 2015 isolated shell from the following link: https://visualstudio.microsoft.com/vs/older-downloads/isolated-shell/ — Hardipsinh Jadeja, Nov 11 '20 at 10:57

score 24 · Accepted Answer · answered Jul 15 '22 at 15:30

24

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>

answered Jul 15 '22 at 15:30

Elton

1,374
16
15

6

Using your solution there is no need to install Visual Studio 2015 Isolated Shell. thanks – Mahyar Aug 11 '22 at 15:14
Life saver! I used this to fix SSMS v19.0.2. – James Poulose Jun 04 '23 at 20:12
Save my life too! SSMS V18.12.1 – Evan Jun 18 '23 at 00:36

score 19 · Answer 2 · answered Dec 12 '20 at 16:59

19

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.

answered Dec 12 '20 at 16:59

Jesús Hagiwara

363
2
8
14

It is same as my last comment. My friend :) – Hardipsinh Jadeja Dec 15 '20 at 05:56
5

@HardipsinhJadeja Because of the question had no answer (in the way SO works), I added one to it based on your comment after trying it by myself, so it's easier for people to see the solution ;) – Jesús Hagiwara Dec 15 '20 at 13:18

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

2 Answers2

Linked