change-the-connection-associated-with-a-query.md

title	Change the Connection Associated with a Query
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.reviewer
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	connections [SQL Server Management Studio], query associations projects [SQL Server Management Studio], connections projects [SQL Server Management Studio], query connections query associations [SQL Server Management Studio]
ms.assetid	7b8851b8-eccb-4e6c-944a-68fa90fc5870
author	markingmyname
ms.author	maghan

Change the Connection Associated with a Query

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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