MS SQL Server Tools - Query Analyzer

Author

Query Analyzer

Bill

2005-11-04, 3:23 am

I installed SQL2005 Developer and my workhorse Query Analyzer is missing.
Granted, there are sexier tools such as Visual Studio and the new design
studio, but I like to write my queries and not draw them. I'm also rather
fond of structuring things in a certain way and not have the development
environment move things around.

Can any of the hardcore database programmers out there recommend a third
party replacement?

Thanks.

-Bill

Tom Moreau

2005-11-04, 9:23 am

Are you not using SQL Server Management Studio - one of the tools that is
part of SQL Server 2005?

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Bill" <bill@discussions.microsoft.com> wrote in message
news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl...
I installed SQL2005 Developer and my workhorse Query Analyzer is missing.
Granted, there are sexier tools such as Visual Studio and the new design
studio, but I like to write my queries and not draw them. I'm also rather
fond of structuring things in a certain way and not have the development
environment move things around.

Can any of the hardcore database programmers out there recommend a third
party replacement?

Thanks.

-Bill

William Stacey [MVP]

2005-11-09, 3:24 am

Use Sql Server Management studio icon, connect to instance/db and then pick
"New Query" to give you a *.sql pad to write and exec your queries. You can
also organize your scripts into projects containing script files and
connections.

--
William Stacey [MVP]

"Bill" <bill@discussions.microsoft.com> wrote in message
news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl...
>I installed SQL2005 Developer and my workhorse Query Analyzer is missing.
>Granted, there are sexier tools such as Visual Studio and the new design
>studio, but I like to write my queries and not draw them. I'm also rather
>fond of structuring things in a certain way and not have the development
>environment move things around.
>
> Can any of the hardcore database programmers out there recommend a third
> party replacement?
>
> Thanks.
>
> -Bill
>
>

D Redfield

2005-11-11, 9:24 am

On the other hand - your sql 2000 Query Analizer WILL interop with SQL
2005.
Personally we like the new tools (once we got friendly with them).
However for hard core T-SQL work, QA still rocks.

Hey Microsoft Guys: What happened to Express Manager? That looks alot like
QA to me. Where did it go?

Hope this helps,

dlr

"Bill" <bill@discussions.microsoft.com> wrote in message
news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl...
> I installed SQL2005 Developer and my workhorse Query Analyzer is missing.
> Granted, there are sexier tools such as Visual Studio and the new design
> studio, but I like to write my queries and not draw them. I'm also rather
> fond of structuring things in a certain way and not have the development
> environment move things around.
>
> Can any of the hardcore database programmers out there recommend a third
> party replacement?
>
> Thanks.
>
> -Bill
>
>

Tibor Karaszi

2005-11-11, 9:24 am

Hi Dennis!

> Hey Microsoft Guys: What happened to Express Manager? That looks alot like
> QA to me. Where did it go?

I'm not MS, but to my knowledge, MS decided that it was inefficient to have two different programs
for managing SQL Server (SSMS and ExpMgr), so they decided that it was more efficient to strip SSMS
from functionality and offer that instead. The plan was to expand ExpMgr with dialogs for backup,
create database and such so in the end ExpMrg would not only be a query tool, but do things as the
full-blown tool also does.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"D Redfield" < dennis_redfield@news
group.nospam> wrote in message
news:eJkhgRs5FHA.1276@TK2MSFTNGP10.phx.gbl...
> On the other hand - your sql 2000 Query Analizer WILL interop with SQL
> 2005.
> Personally we like the new tools (once we got friendly with them).
> However for hard core T-SQL work, QA still rocks.
>
>
> Hey Microsoft Guys: What happened to Express Manager? That looks alot like
> QA to me. Where did it go?
>
>
> Hope this helps,
>
> dlr
>
> "Bill" <bill@discussions.microsoft.com> wrote in message
> news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl...
>
>

William Stacey [MVP]

2005-11-11, 1:23 pm

And IMO, this was a smart move.

--
William Stacey [MVP]

Jasper Smith

2005-11-11, 8:23 pm

Microsoft SQL Server Management Studio Express - Community Technical Preview
(CTP) November 2005
http://www.microsoft.com/downloads/...&displaylang=en

--
HTH

Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"D Redfield" < dennis_redfield@news
group.nospam> wrote in message
news:eJkhgRs5FHA.1276@TK2MSFTNGP10.phx.gbl...
> On the other hand - your sql 2000 Query Analizer WILL interop with SQL
> 2005.
> Personally we like the new tools (once we got friendly with them).
> However for hard core T-SQL work, QA still rocks.
>
>
> Hey Microsoft Guys: What happened to Express Manager? That looks alot
> like
> QA to me. Where did it go?
>
>
> Hope this helps,
>
> dlr
>
> "Bill" <bill@discussions.microsoft.com> wrote in message
> news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl...
>
>

Sponsored Links