how to switch to another server using query analyzer

Question

I have open query analyzer and if I want to switch to another server using query analyzer then How can I do that?

 

answer me if someone knows answer for that

 

thank u

 

maxs

Answer 1

Under the drop down menu for File simply select "Connect".  Then you can connect to another SQL server.

Answer 2

After you have connected to multiple servers (by following what Taztug said) you can switch between the servers by selecting the server from the drop down on the top left of the query analyzer.

Answer 3

There is a list of shorcuts (query analyzer) given here.

http://www.mssqltips.com/tip.asp?tip=1012

 

Answer 4

The guys are correct. SQL Server Management Studio enables you to right click a query window and change the connection to a different server but Query Analyzer does not have this functionality. So just create a new connection as suggested.

Answer 5

after 3 years of waiting there is a solution:

There is an add-in for SSMS, that allows to "remember" connections in "preferred connections" list and switch between easily using combobox on toolbar. Have a look:Name of the tool is SSMSBoost (www.ssmsboost.com)