SQL Query Analyzer Greyed Out

[Matt]

If I open Enterprise Manager through a saved MSC file, the Tools > SQL
Query Analyzer option is greyed out (unavailable). If I open Enterprise
Manager from the Programs menu, Query Analyzer is available. Is there
something specific I need to do with msc?

I created an MSC file and added the Enterprise Manager snap-in.

[Simon Hayes]

"Matt" <ma***********@manning-napier.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

If I open Enterprise Manager through a saved MSC file, the Tools > SQL
Query Analyzer option is greyed out (unavailable). If I open Enterprise
Manager from the Programs menu, Query Analyzer is available. Is there
something specific I need to do with msc?

I created an MSC file and added the Enterprise Manager snap-in.

I tried this and it worked fine for me (SQL 2000 SP4) - if you haven't
applied any servicepacks to your client tools, you could try that, but I
have no idea if it will help.

Simon

[Matt]

Thanks.

I have SP3 installed. Is there a separate SP for the client tools?
Again this is only when I add Microsoft Enterprise Manager to MMC. I
just uninstalled and reinstalled the client tools on my PC and have the
same issues. If I open Enterprise Manager from my programs menu I can
access the Query Analyzer via the Tools menu. I think this behavior is
very awkward.

[Erland Sommarskog]

Matt (ma***********@manning-napier.com) writes:

I have SP3 installed. Is there a separate SP for the client tools?
Again this is only when I add Microsoft Enterprise Manager to MMC. I
just uninstalled and reinstalled the client tools on my PC and have the
same issues. If I open Enterprise Manager from my programs menu I can
access the Query Analyzer via the Tools menu. I think this behavior is
very awkward.

I tried adding Enterprise Manager to MMC, and Query Analyzer was still
available on the menue. But it was the first time I ever ran MMC as such,
so I might have missed something.

But I can't really see this as a big issue. If using the program menu
is akward, why not put a shortcut to Query Analyzer on the desktop?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp