Argh! Bring back Query Analyzer!


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:



  1. Open SSMS

  2. Click Tools in the menu, then select Options

  3. In the At Startup button, click either Open new query window or Open Object Explorer and new query window (my favorite)

  4. Close SSMS

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 ! 🙂

Comments (8)

  1. Dan's Blog says:

    I know, you just want to launch Management Studio (SSMS) and go right into a query window. Why in the

  2. MichaelDotNet says:

    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 🙂

  3. MichaelDotNet says:

    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

  4. Ben says:

    The whole reason I want QA back is because of the long wait on step number 1.

  5. Mr.GoodFun says:

    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.

  6. CDawn123 says:

    I want it back so that I can run multiple queries.

Skip to main content