Share via


How to: 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

  1. In Query Editor, right-click a blank area of Query Editor, point to Connection, and then click Change Connection.

  2. In the Connect to Database Engine dialog box, provide the new connection information, and then click Connect.

See Also

Tasks

How to: Associate a Query with a Connection in a Project
How to: View or Change the Properties of a Connection in a Project

Other Resources

Using Solution Explorer

Help and Information

Getting SQL Server 2005 Assistance