Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 908
Daniel Avatar asked Oct 05 '14 07:10

Daniel


People also ask

How do I find the connection properties in SQL Server?

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...


1 Answers

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

enter image description here

That will bring up the standard connection dialog from which you can connect to whatever other server / instance you want ...

like image 76
marc_s Avatar answered Sep 22 '22 07:09

marc_s