Forum Discussion

Brass Contributor

Sep 15, 2021

Solved

Outlining not working in SSMS 18.x and 19.x

Edit, This problem is also present in SSMS 20.1, Does Microsoft care at all, or are they not capable of fixing this? In SSMS 18.x and 19.x, the outlining feature that allows you to collapse SQL c...

MartinxN
May 15, 2023
Sorry for not updating the original text, this issue is also present in SSMS 19, in fact everything newer than SSMS 17 has this problem

Neilius

Copper Contributor

May 24, 2024

I am using version SSMS 20. This error has occurred for several versions.

I think it occurs because of the size of the script. It stops working for me when my scripts reach a certain size (for me it's about 1Mb.

The solution is t go into Tools / Options / Transact SQL / IntelliSense, tick both options, and IMPORTANT set "Maximum Script Size" to "Unlimited".

If you do this, outlining will come back.

erinstellato
Microsoft
May 24, 2024
Neilius Thank you for sharing your findings! MartinxN, if you are able to test and confirm, that would be very helpful. I can then update the documentation. Thanks!
- MartinxN
  Brass Contributor
  May 30, 2024
  Well, all I can confirm is that I have now set "Maximum Script Size" to "Unlimited" and the problem can still occur
  - erinstellato
    Microsoft
    Jun 07, 2024
    MartinxN Ok...I'm wondering if it's a combination of settings that you have then. Would you be willing to export your settings file and then share it with me? If so, I can provide my email. Thanks.