How to get linked server connection string for all the linked server connections in database server

_{Wednesday, April 12, 2017 11:39 PM}

Team,

Can you please advise How to get linked server connection string for all the linked server connections in database server?

Thanks,

_{Thursday, April 13, 2017 12:10 AM ✅Answered | 1 vote}

--Can you see below query.

exec sp_linkedservers --Returns the list of linked servers defined in the local server.

OR

select sr.name as LinkedServerName **
**      ,is_linked
**       ,sr.provider as ProviderName**
**        ,sr.product as ProductName        **
**        ,sr.data_source as SourceServerName**
From sys.servers sr
Where is_linked = 1

Refer to below link for more info.

Get List of Linked Servers and associated logins

Please Mark this reply as answer if it has solved your issue. Or please use Vote As Helpful if my post was useful so that other forum members can benefit from it.

_{Thursday, April 13, 2017 1:12 AM}

Thank you very much !