Steve Jones, a friend of mine over at sqlservercentral.com, asked me a question the other day that is brought up quite a bit. In earlier versions of SQL Server, we had at least two management tools: Enterprise Manager (EM) and Query Analyzer (QA). EM did the "right-click" stuff and QA did the query stuff. In SQL Server 2005 (and higher) we've combined these into one tool - SQL Server Management Studio (SSMS).
We get asked a lot why we did that. And if we'll ever bring back the QA tool. We hear: "I just want to jump in, run a query, and get out." But did you know you can do that today?
Here are the steps:
Now whenever you open you're back at the Query Window, just like QA.
Oh, and I know it's slower. We're working on that ! :)
PingBack from http://www.artofbam.com/wordpress/?p=3683
I know, you just want to launch Management Studio (SSMS) and go right into a query window. Why in the
That's all well and good, but what I'd rather have is a choice to do one or the other... Like... command line options :)
Whipped up a quick batch routine that will opens up MMS in a QA like way: http://michaeldotnet.blogspot.com/2007/09/query-analyzer-resurrected.html
If you miss Query Analyzer you can still vote on the Connect site for this tool: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=297428&wa=wsignin1.0
The whole reason I want QA back is because of the long wait on step number 1.
I want Query Analyzer back just because it was lightweight and easy to pop open from another app, or from the desktop, etc. It's a lot of overhead for people to jump into SSMS and do a quick query. Bad move on MS part.
I want it back so that I can run multiple queries.