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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

770 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