|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Query AnalyzerI 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 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" <b***@discussions.microsoft.com> wrote in message I installed SQL2005 Developer and my workhorse Query Analyzer is missing.news:uuIVYUQ4FHA.696@TK2MSFTNGP09.phx.gbl... 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 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. -- Show quoteWilliam Stacey [MVP] "Bill" <b***@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 > > 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 Show quote "Bill" <b***@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 > > Hi Dennis!
> Hey Microsoft Guys: What happened to Express Manager? That looks alot like I'm not MS, but to my knowledge, MS decided that it was inefficient to have two different programs > QA to me. Where did it go? 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. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "D Redfield" <dennis_redfield@newsgroup.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" <b***@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 >> >> > > Microsoft SQL Server Management Studio Express - Community Technical Preview
(CTP) November 2005 http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en -- Show quoteHTH 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@newsgroup.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" <b***@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 >> >> > >  |
|||||||||||||||||||||||
Other interesting topics