Posted by Erland Sommarskog on 07/27/06 21:33

(alvinstraight38@hotmail.com) writes:
> I am trying to access a client's SQL query anaylzer to run a SQL
> script, and I can not find it anywhere.
>
> I have not used SQL in a few years, but I would always see a menu in
> the program list, or go to Enterprise Manager. I could not find any
> menu listings for SQL. I went to Programs - Administrative and did not
> see anything related to SQL yet I know that I am looking at their SQL
> server.
>
> I don't know if they are running SQL 2000 or 2005. Can anyone give me
> a directory path or perhaps the exe name that launches query analyzer?

Go to C:\Program Files\Microsoft SQL Server and look for the directories
80 (SQL 2000) and 90 (SQL 2005). Continue to tools\binn. Query Analyzer
is ISQLW.EXE, but on SQL 2005 you need to look for SQLWB.EXE, which is
SQL Server Management Studio.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]