How to enable Outline Statements

Posted on 2012-08-23
Last Modified: 2013-01-29
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?
Question by:brettr
    LVL 96

    Expert Comment

    by:Bob Learned
    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?

    Author Comment

    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.
    LVL 37

    Expert Comment

    Perhaps it's bug-related?  Do you have the latest SP for your SQL Server version installed?
    LVL 35

    Accepted Solution


    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


    Author Comment

    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

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now