How to change the connection for the current tab in Microsoft SQL Server Management Studio

Question

I want to run a query in SQL Server Management Studio in several databases on different servers.

I am already connected to these servers in the object explorer.

Is there a quick way to change the connection of the current request tab to another server without having to log in again (without using the connection to change) and without opening a new tab.

Answer 1

Right-click in the query window and select Connection > Change Connection :

A standard connection dialog box will appear, from which you can connect to any other server / instance that you want ...