code outlining not always working in SSMS 18.8

Martin Nielsen 1

code outlining stops working in SSMS 18.8 (and all previous 18.x versions I have tried) when I open the program it works fine in the beginning, but then after a while it suddenly stops working. What I have discovered so far is that there may be a problem if some object have special names, specifically I found that the following piece of code would make outlining disappear for the entire file: SELECT ....... S.End .... FROM ..... I know end is a reserved word but i'm surprised that it ruins outlining for the whole file, especially since SSMS 17.x handles this like a pro I tried adding brackets, which did not help until after I commented the offending line out and back in there may be other examples like this, but this is the first where I was able to pinpoint the reason for the problem

Viorel 114.7K Reputation points

2021-03-02T08:59:19.417+00:00

It seems difficult to reproduce. If possible, show a problematic query.
CathyJi-MSFT 21,136 Reputation points Microsoft Vendor

2021-03-05T01:50:43.703+00:00

Hi,

Could you share us the information that Viorel mentioned?
Martin Nielsen 0 Reputation points

2023-05-12T07:08:53.1066667+00:00
When the problem appears even a query like this fails to collapse:

SELECT * FROM sys.objects
Martin Nielsen 0 Reputation points

2023-05-12T07:11:08.76+00:00

The problem is present in all versions after SSMS 17, never had the problem in SSMS 17

Sometimes it works after restarting SSMS 19 but no guarantee

Share via

code outlining not always working in SSMS 18.8