Display Results in a Separate Tab in SSMS Query Editor

By default, the query and query results in SQL Server Management Studio (SSMS) are displayed in the same query editor tab:

query_and_results_same_tab

Query results can be set to open in a separate tab together with messages and execution plans.

Click Tools -> Options

In Options window choose Query Results -> SQL Server -> Results to Grid or Results to Text
Check "Display results in a separate tab"
You can also check "Switch to results tab after the query executes"
Click OK

Results to Grid:
query_and_results_separate_tab_grid

Results to Text:
query_and_results_separate_tab_text

Open new Query editor window to use this settings:

query_and_results_separate_tab

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">