Code folding isn't working in Management Studio?

Question

I have SQL Management Studio 10.50.1600.1, and I have Outline statements turned on in Tools -> Options -> Text Editor -> Transact-SQL -> IntelliSense, but alas it's not giving me the expander on the BEGIN statements.

I've also verified that IntelliSense is enabled for the query window I'm in, and SQL CMD Mode is disabled.

Further, I've verified that I'm not connected to a down leveled server, I'm connected to a server that is version 10.50.2500.0.

Finally, I've verified the version of the database itself, it's a v100 database.

NOTE: the actual IntelliSense isn't working either, and this is a SQL Express instance, I don't know if that makes any difference at all but I thought I might mention it.

Answer 1

Verify your installation meets these requirements. Install SQL Server 2008 R2 SP2. This should get SSMS version to 10.50.4000. After the service pack is applied, check to see if the problem is resolved.

If this doesn't resolve the intellisense issue, the next step is to reinstall VS 2010 SP1.

More information on the conflict can be found through KB2531482. I have seen installations where intellisense is still broken with SSMS 2008 R2 SP2. The VS 2010 SP1 reinstall was able to resolve.

Answer 2

This happened to me with ssms 2014 and 2016 preview.

I can't be arsed to try and reinstall this and that.

So I just created some keyboard shortcuts for "hide selection" and "toggle outlining expansion". So I have to choose what gets outlined, but it's better than nothing. Not too much trouble. A workable solution for me, may work for you.