Query Analyzer in Sql Server 2005

7 Sep 2006 1:01 PM

Raj

Hi

I know that the Query Analyzer is merged with an tool in 2005.
So which edition of Sql Server 2005 I need to install to have Query Analyzer
on my machine?

Thanks
Raj

7 Sep 2006 1:09 PM

Hari Prasad

Hi,

There is no query analyzer in SQL Server 2005. SQL Server Management studio
comes along with all versions (except SQL Express);
All you have to do is connect the SQL Server from management studio and
right click above the server name
in object explorer and choose "New Query"

If you do not have the SQL Management studio; you need to install it using
setup.

Thanks
Hari
SQL Server MVP

FYI, SQL 2000 Query analyzer can also connect to a SQL 2005 database
instance.

Show quote

"Raj" <R**@discussions.microsoft.com> wrote in message
news:2A847A24-5823-4D0D-A32A-5D2C35DFBA48@microsoft.com...
> Hi
>
> I know that the Query Analyzer is merged with an tool in 2005.
> So which edition of Sql Server 2005 I need to install to have Query
> Analyzer
> on my machine?
>
> Thanks
> Raj

7 Sep 2006 4:04 PM

Arnie Rowland

And note that there is a version of SSMS for SQL Express.

See: http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"Hari Prasad" <hari_prasa***@hotmail.com> wrote in message
news:OD1mt6n0GHA.2196@TK2MSFTNGP03.phx.gbl...
> Hi,
>
> There is no query analyzer in SQL Server 2005. SQL Server Management
> studio comes along with all versions (except SQL Express);
> All you have to do is connect the SQL Server from management studio and
> right click above the server name
> in object explorer and choose "New Query"
>
> If you do not have the SQL Management studio; you need to install it using
> setup.
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> FYI, SQL 2000 Query analyzer can also connect to a SQL 2005 database
> instance.
>
> "Raj" <R**@discussions.microsoft.com> wrote in message
> news:2A847A24-5823-4D0D-A32A-5D2C35DFBA48@microsoft.com...
>> Hi
>>
>> I know that the Query Analyzer is merged with an tool in 2005.
>> So which edition of Sql Server 2005 I need to install to have Query
>> Analyzer
>> on my machine?
>>
>> Thanks
>> Raj
>
>

7 Sep 2006 9:56 PM

Erland Sommarskog

Raj (R**@discussions.microsoft.com) writes:

> I know that the Query Analyzer is merged with an tool in 2005.
> So which edition of Sql Server 2005 I need to install to have Query
> Analyzer on my machine?

SQL 2000. :-)

As the other posters have pointed out there is a new tool for SQL 2005,
but whether you like it is a matter of taste. So having a QA around as
backup if you freak out on Mgmt Studio is not a bad idea.

--
Erland Sommarskog, SQL Server MVP, esq***@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