• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 491
  • Last Modified:

How to enable Outline Statements

I have this checked in Options but still do not have the plus/minuses in the left hand column to collapse/expand code.  But sometimes they are there.  Any one know how to have this always enabled?
1 Solution
Bob LearnedCommented:
I am not quite sure that I understand the context of your question, and which option that you are talking about.  Could you please attach a screen shot?
brettrAuthor Commented:
Here are the steps in Management Studio:

Tools >> Options.  The Options window appears.  Navigate to Text Editor >> Transact-SQL >> IntelliSense.  I have all three options checked.
ValentinoVBI ConsultantCommented:
Perhaps it's bug-related?  Do you have the latest SP for your SQL Server version installed?
David ToddSenior DBACommented:

What version of SSMS?

Tools | Options | Text Editor | IntelliSense | Outline statements - Is this the option you have ticked?

SSMS EditorNote the following from the screen-shot.

use tempdb can't collapse.

The select @@servername  etc collapses as a block

The select from .. files statements can collapse as both sttements and a block

brettrAuthor Commented:
I'm running MSSMS 10.50.2500.  The option above is checked.  Currently, I can collapse on all my open query windows.  Periodically, I'll get one where that is not an option.

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now