29

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

Improve this question
2

2 Answers 2

Reset to default
31

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>
Improve this answer
Sign up to request clarification or add additional context in comments.

5 Comments

Using your solution there is no need to install Visual Studio 2015 Isolated Shell. thanks
Life saver! I used this to fix SSMS v19.0.2.
Save my life too! SSMS V18.12.1
Brilliant, thanks. I honestly struggle to write SQL correctly without Poor Man's SQL Formatter. It helps find stray brackets for one thing.
@elton Thanks for the solution, it works on v19 but in v20 , not working
20

For the versions of the plugin that supports SSMS 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.

The formatter is now enabled.

Improve this answer

1 Comment

@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 ;)

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.