在 SQL Server 中更改链接服务器的属性

2021-09-10 00:00:00 tsql sql-server-2008 sql-server

有什么方法可以更改现有链接服务器的属性(产品名称、数据源、提供程序字符串等...)?当我转到属性屏幕时,所有选项都变灰了.

Is there any way to change the properties (Product name, data source, provider string, etc...) of an existing linked server? When I go to the properties screen, all the options are grayed out.

推荐答案

我最终创建了一个新的链接服务器并删除了旧的.不幸的是,无法编辑现有实例

I ended up creating a new linked server and deleting the old one. Unfortunately, there is no way to edit an existing instance

相关文章