Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!
all groups > sql server (alternate) > july 2006 >

sql server (alternate) : How to Access Query Anaylzer?


alvinstraight38 NO[at]SPAM hotmail.com
7/27/2006 7:12:26 AM
Hi everyone,

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?
Thanks!
Bobbo
7/27/2006 8:14:34 AM
[quoted text, click to view]

Try Start > Run > "isqlw.exe"

Works for me!
Erland Sommarskog
7/27/2006 9:33:44 PM
(alvinstraight38@hotmail.com) writes:
[quoted text, click to view]

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
Hugo Kornelis
7/27/2006 10:06:01 PM
[quoted text, click to view]

Hi alvinstraight38,

Have you checked to see if the client tools were installed on the
workstation you're using? If not, find the install CD, run setup and
choose to install client tools only.

--
AddThis Social Bookmark Button