I want to run a query in SQL Server Management Studio on 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 query tab to a different server without the need to login again (without using change connection) and without opening a new tab.
In MS SQL Server, the Database Properties dialog has the "View Connection Properties" link over on the left. Clicking that brings the "Connection Properties" dialog with properties of the current connection, such as Authentication Method, Network Protocol, Computer Name, etc...
Right-click in the query window and select Connection > Change Connection
:
That will bring up the standard connection dialog from which you can connect to whatever other server / instance you want ...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With