Wednesday, January 09, 2008 2:37 PM
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
Wednesday, January 09, 2008 2:52 PM
Under the drop down menu for File simply select "Connect". Then you can connect to another SQL server.
Wednesday, January 09, 2008 3:03 PM
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.
Wednesday, January 09, 2008 3:08 PM
There is a list of shorcuts (query analyzer) given here.
Wednesday, January 09, 2008 3:09 PM
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.
Sunday, March 04, 2012 7:31 PM
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)