Query Analyzer in SQL 2005

[RemingtonSteel]

Hello!
Where can I find the Query Analyzer in SQL 2005 or the equivalent functionality ?

Thanks!
Gene

 

[gmmastros]

You'll want to use SQL Server Management Studio. It's kind-of-a merge between Enterprise Manager and Query Analyzer. If you have SQL2005 installed (and you installed the client tools) you you should already have this installed.

If you are using SQL Express, then you will want to download SQL Server Management Studio Express.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[JoeAtWork]

Once you have Management Studio up and running, hit the "New Query" button.

 

[TysonLPrice]

I like keeping SQL 2000 Query Analyzer running along with 2005 just because I prefer the Query Analyzer presentation. You can't use the object browser but writing queries works fine.