Qry Analyzer without Object Browser?? 1

[dfwalton]

I just started a new job, and the version of Query Analyzer they have appears to not have the object browser. They use Enterprise Manager to see what's what. Arrgh. Is it true that there is an edition out there without the OB? Can one install it, or is there a secret handshake that will bring it to life.
Thanks

 

[mutley1]

If you're using SQL 2000, then just next to the drop down list of databases in QA, theres the object browser button (a box with objects coming out of it. Hover over it and you should see the description.

HTH.

M.

 

[gmmastros]

You can press F8 to toggle the visibility of the object browser.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Catadmin]

Or go to Tools -> ObjectBrowser -> Show/Hide if you can't remember F keys. @=)





Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[dfwalton]

Yeah, I did try all those things. F8 doesn't work. There is no tools menu. This thing is old and brain dead!

 

[Catadmin]

What version of SQL are you using? Do a "SELECT @@VERSION". Without the double quotes of course.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mutley1]

If it's just EM on your local machine as opposed to the server you might want to unistall and reinstall the client tools.

 

[gmmastros]

If I recall correctly, the version of Query Analyzer that shipped with SQL Server 7 did not have an object browser.

You could try downloading the evaluation version of sql 2000 and installing ONLY the client tools. You can use Query Analyzer (from the 2000 version) to connect to a sql 7 database.

http://www.microsoft.com/downloads/...e1-f44c-4781-a6bb-f60e02dc1335&displaylang=en

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Catadmin]

George,

I was wondering about that. That's why I asked him what version he was using. Thanks for clarifying.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[gmmastros]

Catadmin,

It was actually your request for additional information that caused me to think about the 'version 7' version of query analyzer.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dfwalton]

GMMASTROS -- Thanks for the clarification between SQL Server 7 and 2000 -- clearly what I need are the 2000 tools. The link you provided allows downloads of the entire SQL 2000 package, which is very bulky. Is there anywhere one can (still) get the Query Analyzer tool by itself, or will I need to look to 3rd parties?
Thanks

David

 

[Catadmin]

Query Analyzer doesn't come by itself. The client tools for 2000 include Enterprise Manager & Books Online, but they are only installable from the actual SQL Server install package. You can install them by themselves, you just need the entire SQL Server 2000 install to get them.

And, as far as I know, there are no 3rd party tools that actually replace EM & QA, though there are 3rd party tools that do mimic the look of the interfaces.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"