QA stuck on 'Results in Text'

How do I get it back to the default 'Results in Grid'? No matter if I
change it and close, change is and save and close, it always comes up as
"Results in Text" and has to be changed everytime I open QA.
Scott
Configure it in Tools -> Options ->Results, if you are not already doing
that. It sure remembers this setting.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Wm. Scott Miller" <Scott.Miller@.spamkillerwvinsurance.gov> wrote in message
news:OLODrcgjFHA.3348@.tk2msftngp13.phx.gbl...
How do I get it back to the default 'Results in Grid'? No matter if I
change it and close, change is and save and close, it always comes up as
"Results in Text" and has to be changed everytime I open QA.
Scott
|||Yeah, the key word is "should" but it doesn't as I said in my original post.
I have not had problems in the past. But now I am completely stuck on
Results as Text no matter how I change it.
Scott
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%239S5cugjFHA.3064@.TK2MSFTNGP15.phx.gbl...
> Configure it in Tools -> Options ->Results, if you are not already doing
> that. It sure remembers this setting.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Wm. Scott Miller" <Scott.Miller@.spamkillerwvinsurance.gov> wrote in
> message
> news:OLODrcgjFHA.3348@.tk2msftngp13.phx.gbl...
> How do I get it back to the default 'Results in Grid'? No matter if I
> change it and close, change is and save and close, it always comes up as
> "Results in Text" and has to be changed everytime I open QA.
> Scott
>
>
|||Wm. Scott Miller wrote:
> Yeah, the key word is "should" but it doesn't as I said in my
> original post. I have not had problems in the past. But now I am
> completely stuck on Results as Text no matter how I change it.
> Scott
>
Try setting the following key to 0:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL
Query Analyzer\Options\ResultsTab\DefResultsTarget
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David:
That key is already set to 0 (zero). So I tried to set it to 1 and open the
app. That fixed it. Thanks for the key.
Scott
"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uLdfgamkFHA.4000@.TK2MSFTNGP12.phx.gbl...
> Wm. Scott Miller wrote:
> Try setting the following key to 0:
> HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL
> Query Analyzer\Options\ResultsTab\DefResultsTarget
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com

QA options

Hello,

In QA there are options for displaying results in TEXT, Grid or to a file. It is possible to lock these options so that only one is available. How is it possible to change it back to the default so that any of the 3 can be selected?

Hi there OldtimerMCSE,

There is an option.

From within SSMS go to Tools, Option, Query Results, SQL Server.

There you can select the destination.

Terrence Nevins

SQL Server Program Manager

|||

i dont think it is possible to lock/unlock the options

you may need to write your own query analyzer

QA options

Hello,

In QA there are options for displaying results in TEXT, Grid or to a file. It is possible to lock these options so that only one is available. How is it possible to change it back to the default so that any of the 3 can be selected?

Hi there OldtimerMCSE,

There is an option.

From within SSMS go to Tools, Option, Query Results, SQL Server.

There you can select the destination.

Terrence Nevins

SQL Server Program Manager

|||

i dont think it is possible to lock/unlock the options

you may need to write your own query analyzer