Query Analyzer on client machine

Hello:

I need someone to make this easy for me.  I have a windows 7 client machine that I want to be able to run queries on a SQL Server 2008 database.

I don't know what product I need to download and install on my client machine.  Basically, I want to be able to run Query analyzer on my client machine against the networked 2008 SQL server.

There are just too many products/possible solutions for me to sift thorough.

Please let me know which one I need to download and general instructions would be appreciated.

Thank you!  
MeowserMAsked:
Who is Participating?
 
Faiga DiegelSr Database EngineerCommented:
Install the SQL client tool with the SQL Server Management Studio. When you have this installed on your machine, you can connect to different DB servers (of course there are some settings on the SQL server that you want to connect to for remote connections, firewall settings, security, etc)
0
 
sammySeltzerCommented:
You can use sql server web admin.

That's what I use. Install it on your PC, point to your remote db and vavoom, you are working without having to get into sql server db.

http://www.microsoft.com/download/en/details.aspx?languageid=f49e8428-7071-4979-8a67-3cffcb0c2524&displaylang=en&id=10299

0
 
MeowserMAuthor Commented:
Thank you.  I installed 2008 management studio
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.