Get Linked Server Configuration

,

just copy and run.

--This query will return the linked servers infromation configured in the server.
SELECT a.NAME,a.product,a.provider,a.data_source,a.catalog ,
f.[name],b.[uses_self_credential],b.[remote_name] FROM sys.[linked_logins] AS b
INNER JOIN sys.servers AS a
ON a.[server_id]=b.[server_id]
INNER JOIN sys.[server_principals] AS f
ON b.[local_principal_id]=f.[principal_id]

Rate

3.71 (7)

Share

Share

Rate

3.71 (7)