Query Analyzer. What settings to see the data output again? -- sql server connect

dba_222 NO[at]SPAM yahoo.com
8/8/2006 3:08:33 PM

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
8/8/2006 3:12:11 PM

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=F6str=F6m
MCP, MCAD

[quoted text, click to view]

dba_222 NO[at]SPAM yahoo.com
8/8/2006 3:23:36 PM

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.

[quoted text, click to view]

Arnie Rowland
8/8/2006 4:19:56 PM

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

[quoted text, click to view]
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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : Query Analyzer. What settings to see the data output again?