Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I upgraded to SQL Server 2008 R2 Web from Express with Advanced Services recently and code outlining went away. How do I get my collapsible code back?


share|improve this question
Have you checked the options in SSMS to see if it was just turned off during the upgrade? – Shawn Melton Sep 25 '12 at 14:21
Yes.I made sure all was the same as before the upgrade took place. – Alex Erwin Sep 25 '12 at 15:12
Try turning off the option, then turning it back on. – Jon Seigel Sep 25 '12 at 16:16
When 2008 first came out I remember there being issues with it not working depending on what engine you were connected to. There was a popular tool as a work around that you can find here: – RThomas Sep 25 '12 at 16:20
Not sure if this helps, but Intellisense is not working either. – Alex Erwin Sep 26 '12 at 1:10

Apply the latest service packs was the answer. Applied SP1 and cumulative updates from MS. Should have known, Windows, the service pack wonder.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.