Solved

Replacement SQL2008 query analyzer tool

Posted on 2010-08-24
3
1,027 Views
Last Modified: 2012-05-10
I would like to find a standalone query analyzer that will work well with SQL 2008,   I realize I can utilize the tools embedded in the Management Studio, but I miss the ability to have many instances of the query analyzer open at the same time so I can easily toggle between databases and different projects without issues.   It is not uncommon for me to have eight instances of Query Analyzer open at once with dozens of queries running in each.  Additionally I like the small footprint the standalone product provided which is not available using the Management Studio.   Has anyone found a good tool that has been developed to allow for the old school SQL 2000 style query analyzer?  

Thanks,
Mike
0
Comment
Question by:OCUW
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 2

Assisted Solution

by:jdhalverson
jdhalverson earned 125 total points
ID: 33518257
I know you can have multiple instances of Management Studio open and use sqlcmd to run sql scripts against a sql 2008 server there is also this:  http://www.albahari.com/queryexpress.aspx
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 33518262
Just pointing out. You can start multiple instances of SSMS. Maybe this is your solution.

Cheers Marten
0
 
LVL 9

Accepted Solution

by:
sas13 earned 125 total points
ID: 33518659
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question