Get all connected DBLINK information using SP_LINKEDSERVERS in sql server

Sp_LinkedServers is a system SP. It will return the list of linked servers defined in the local server.

I am executing this SP.

EXEC SP_LINKEDSERVERS

 

Here we will get the list of linked server.

Inside this SP

create procedure sys.sp_linkedservers as     select         SRV_NAME            = srv.name,         SRV_PROVIDERNAME    = srv.provider,         SRV_PRODUCT         = srv.product,         SRV_DATASOURCE      = srv.data_source,         SRV_PROVIDERSTRING  = srv.provider_string,         SRV_LOCATION        = srv.location,         SRV_CAT             = srv.catalog     from         sys.servers srv     order by 1

Column details

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.