How to save collapse sections of the query window and save it like that

  • itmasterw 60042

    SSCrazy

    Points: 2681

    Hi,

    My manager would like it that when he collapses certain parts of the query and saves it, it will open that way; and not have it all expanded.

    Is there a way to do this?

    Thank you

  • ryanbesko

    Ten Centuries

    Points: 1245

    Unfortunately SSMS does not offer this feature.  It might be worth looking into doing your database development in the full version of Visual Studio.  It does what you are asking for several different file types.

  • itmasterw 60042

    SSCrazy

    Points: 2681

    HI,

    and thanks for the reply.

    I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there?

    Please let me know.

    Thank you

  • Phil Parkin

    SSC Guru

    Points: 243596

    itmasterw 60042 wrote:

    HI, and thanks for the reply. I do have a full version of VS, but am not familiar with how you do what you do in SSMS in there? Please let me know. Thank you

    This functionality is not available in VS for .sql files. It is available for other file types, C#, for example.

    If you can use third party tools, take a look at SSMS Boost, which is an SSMS add-on. It facilitates the behaviour you desire, through the use of --region and --endregion comments.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply