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?


  • Have you checked the options in SSMS to see if it was just turned off during the upgrade?
    – user507
    Sep 25, 2012 at 14:21
  • Yes.I made sure all was the same as before the upgrade took place.
    – Alex Erwin
    Sep 25, 2012 at 15:12
  • 1
    Try turning off the option, then turning it back on.
    – Jon Seigel
    Sep 25, 2012 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: ssmstoolspack.com
    – RThomas
    Sep 25, 2012 at 16:20
  • Not sure if this helps, but Intellisense is not working either.
    – Alex Erwin
    Sep 26, 2012 at 1:10

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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