Change the Connection Associated with a Query

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

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

Solution Explorer
Associate a Query with a Connection in a Project
View or Change the Properties of a Connection in a Project