如何更改Microsoft SQL Server Management Studio中当前选项卡的连接 [英] How can I change the connection for current tab in Microsoft SQL Server Management Studio

问题描述

我想在不同服务器上的几个数据库上运行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.

推荐答案

在查询窗口中单击鼠标右键，然后选择连接>更改连接：

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

这篇关于如何更改Microsoft SQL Server Management Studio中当前选项卡的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！