This can be controlled in Tools | Options | Database | Script Result | Result Sets.
Number of tabs to display:- Select the maximum number of script result sets to display in the Result Sets tab.
Default: 5
Maximum number of result sets from each query:- Enter the maximum number of results that can display when executing a single query that returns multiple result sets.
Default: 100
All in one tab/ One tab per query:- Select whether to display results in a single tab if a query returns multiple results or display each result from the query in a separate tab.
Default: All in one tab
Example: If only one tab is required so that every time a query is run, the results populate the same tab, then set Number of tabs to display to 1.
