Can you view linked server properties in MS SQL server Management Studio without dropping server?

e3bfsja2 于 2023-11-16 发布在 SQL Server

关注(0)|答案(2)|浏览(146)

Why do you have to drop a linked server before you can make changes to the server? Why can you not view properties of the server i.e. username access rights etc? Is it practical to drop a table first before having the ability to alter it and make changes? Is it safe to use drop and create to in order to get properties of the linked server or will the settings be removed? Is there a SQL command that would allow you to view properties of a linked server?

sql-server

来源：https://stackoverflow.com/questions/43549134/can-you-view-linked-server-properties-in-ms-sql-server-management-studio-without

2条答案

按热度按时间

hjqgdpho1#

Yes, you can view the properties of the linked servers, and you may make changes on tabs #2 and #3. The first tab can not be changed, IE: server type and name.

To see the linked servers in MSSMS, look under "Server Objects", Linked Servers", then right click on the linked server and select properties.

赞(0）回复(0）举报 2023-11-16

rsl1atfo2#

To check the properties of linked servers you can use: