Query Analyzer. What settings to see the data output again?

[dba_222@yahoo.com]

Dear experts,

I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.

When I was using my query analyzer last, a few months ago, I
was tuning some strange code. I changed some settings to
see what was going on.

Now, when I login, and do a query, I see lots of tuning info. see:

http://www.geocities.com/dba_222/querya.jpg

But I don't see any output from the query at all!!!!

Yes, there is data in the table, as my coworker does get
a number from the query.

Is this familiar to anyone?
Can anyone tell me what the setting is, that I need to change back,
in order to see the output?

I'm sure it's either a SET command, or a setting in Query Analyzer.


Thanks a lot!

[Johan Sjöström]

Re: Query Analyzer. What settings to see the data output again?

CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.

Cheers,
Johan Sjöström
MCP, MCAD


dba_...@yahoo.c om wrote:

Dear experts,
>
I hate to ask such a seemingly dumb question.
But I have spent some time trying to solve this already
to no avail.
>
When I was using my query analyzer last, a few months ago, I
was tuning some strange code. I changed some settings to
see what was going on.
>
Now, when I login, and do a query, I see lots of tuning info. see:

http://www.geocities.com/dba_222/querya.jpg

>
But I don't see any output from the query at all!!!!
>
Yes, there is data in the table, as my coworker does get
a number from the query.
>
Is this familiar to anyone?
Can anyone tell me what the setting is, that I need to change back,
in order to see the output?
>
I'm sure it's either a SET command, or a setting in Query Analyzer.


Thanks a lot!

[dba_222@yahoo.com]

Re: Query Analyzer. What settings to see the data output again?

Thanks for responding.

That did something. But it didn't bring the results back.
It toggled the output I had on the bottom, to just the query.


I think I figured it out. I toggled
menu, query, show execution plan

That gave me the results (of the query), or the execution plan.
But not both.




Johan Sjöström wrote:

CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.

Cheers,
Johan Sjöström
MCP, MCAD
>

[Arnie Rowland]

Re: Query Analyzer. What settings to see the data output again?

You may want to go to [Tools], [Options]

Click on [Editor], then select [Tabbed Mode].

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


<dba_222@yahoo. comwrote in message
news:1155075816 .414877.23280@m 73g2000cwd.goog legroups.com...
Thanks for responding.

That did something. But it didn't bring the results back.
It toggled the output I had on the bottom, to just the query.


I think I figured it out. I toggled
menu, query, show execution plan

That gave me the results (of the query), or the execution plan.
But not both.




Johan Sjöström wrote:

CTRL+R brings back the results pane. There's an icon for it as well in
the toolbar menu, usually on the top right.
>
Cheers,
Johan Sjöström
MCP, MCAD
>