Hi,

We are trying to track Linked servers configuration. Is it possible to query Linked server configuration like mappings, options, etc?

Thanks

Hi jori5,

You can check configuration information and modification information for  linked servers by running the sp_linkedservers stored procedure.

exec sp_linkedservers

To generate a detailed  summary report of the Linked Servers in SSMS, run the following query:

SELECT *

FROM sys.Servers a

LEFT OUTER JOIN sys.linked_logins b ON b.server_id = a.server_id

LEFT OUTER JOIN sys.server_principals c ON c.principal_id = b.local_principal_id

Reference:
http://jwcooney.com/2011/10/26/sql-server-how-to-list-the-full-properties-of-all-linked-servers/


Thanks,
Lydia

If youre interested in listing all of your linked servers and their OLE DB providers, run the command

EXEC sp_linkedservers
You can also list the servers that can be accessed as OLE DB data sources by running the command

SELECT * FROM sysservers