The following Stored procedure will returns the list of linked servers defined in the server in which we are executing it.

sp_linkedservers

This procedure will return the following informations about the linked server
Column name
Data type
Description
SRV_NAME
sysname
Name of the linked server.
SRV_PROVIDERNAME
nvarchar(128)
Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCT
nvarchar(128)
Product name of the linked server.
SRV_DATASOURCE
nvarchar(4000)
OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRING
nvarchar(4000)
OLE DB provider string property corresponding to the linked server.
SRV_LOCATION
nvarchar(4000)
OLE DB location property corresponding to the specified linked server.
SRV_CAT
sysname
OLE DB catalog property corresponding to the specified linked server.

Or… you can use following SQL Scripts to lists all linked servers

select * from master..sysservers
Hope this helps!

Powered by WPeMatico

Categories: SQL

Related Posts

SQL

SQL – Get Procedure/Function/Trigger Name

Problem: When I write any procedure for UI functionality, I may require to throw the Procedure Name to UI if any error occurs, This will help people to identify/Isolate the bug if occured Also I Read more…

SQL

Cannot login to SSAS 2008 from SSMS?

Issue: When I tried to connect to a named instance of SQL Server 2008 Analysis Services (SSAS) by using SQL Server Management Studio, I received the following error message intermittently: