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 - Debugger

How do I input a blank but not NULL value into a varchar parameter during
sproc debugging?
It seems that no matter I typed ('') / '' or leave it blank. It still not a
value that I wanted for the params.
LeonardP
Have you tried initializing the parameter to '' when it is declared? If no
value is provided, it uses the '' for it's value.
Ex: @.P1 varchar(10) = '', @.P2 varchar(5), etc...
"Leonard Poon" <leonardpoon@.hotmail.com> wrote in message
news:O$dgcLpTEHA.164@.TK2MSFTNGP12.phx.gbl...
> How do I input a blank but not NULL value into a varchar parameter during
> sproc debugging?
> It seems that no matter I typed ('') / '' or leave it blank. It still not
a
> value that I wanted for the params.
> LeonardP
>