Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


In Query Analyzer (SQL 2K), with multiple results sets, can the grids display in separate tabs like in SQL 7

Posted on 2005-02-28
Medium Priority
Last Modified: 2006-11-17
In SQL 7, when there were multple result sets returned in grid format, each grid was a separate tab.  (There was a limit of something like 10 result sets that could be displayed this way.)

In SQL 2K, all the grids get stacked in a single "grids" tab.  It seems that this accommodates more results sets but the navigation is far more cumbersome.

Is there a way to seeing SQL 7 like behavior?

Question by:hsardis
LVL 27

Accepted Solution

ptjcb earned 252 total points
ID: 13424359
Short answer: No.

Long answer: I checked various sites and went through the QA setup and there is nothing that allows you to set multiple tabs instead of one hunk of results.

I downloaded a 3rd party program, ApexSQL Edit, that gives me the "older" tab results. I bought this one after using it for 20 days. A nice replacement for QA.
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 248 total points
ID: 13424626
>>Is there a way to seeing SQL 7 like behavior?<<
Not the answer to you question, but check out Tabbed mode (instead of Splitter mode)

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

578 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