>In SQL2008 management studio I could open and close blocks of sql in procedures by clicking the + sign beside them.
>
>Now I have lost this.
>
>I've tried changing Tools | Options | Text Editor | Transact-SQL | Intellisense | Outline Statements but still no script outlining.
>
>Any ideas what I've done ? and how I get it back ?.
>
>Thanks
I didn't know that was built in bu there is a free thing called SSMS Tools that will allow you to define any area as a region and expand and collapse as you describe. Has other cool features. I use it a lot on big SPs
http://www.ssmstoolspack.com/
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.