Change the Connection Associated with a Query
A query can be executed against several different servers or databases by changing the connection used by the query.
To change the connection associated with a query
In Query Editor, right-click a blank area of Query Editor, point to Connection, and then click Change Connection.
In the Connect to Database Engine dialog box, provide the new connection information, and then click Connect.