How do I run sql query analyzer?

[ceyhorn]

How do I run sql query analyzer? I'm trying to install some .sql files to create a database, but I cannot figure out how to open or use the query analyzer. Thanks in advance.
Chris

 

[johnherman]

It can be reached through Enterprise Manager (aka MMC Microsoft Management Console). It is also available as a Client utility via the Client setup.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[SQLBill]

Have you loaded either SQL Server or the SQL Server Client Tools on the machine you are planninng on using?

If so, you can find Query Analyzer at Start>Programs>Microsoft SQL Server>Query Analyzer.

-SQLBill

 

[ceyhorn]

Bill,

I have installed SQL Server but I just downloaded it from the website. Is there anyplace to download these components separetly? If not what else can I use to execute the .sql files?. Thanks again,

Chris

 

[ceyhorn]

I figured it out, I used osql to execute them.

chris

 

[SQLBill]

You say you downloaded it from the website. I don't believe you can do that with "SQL Server". Do you mean MSDE (which is really different than SQL Server)?

If so, then MSDE doesn't have Query Analyzer or Enterprise Manager. You have to use OSQL or a front-end application like MS Access or Visual Basic.

-SQLBill