Search this blog

Friday, February 15, 2013

How To: Lists Linked Server

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!

2 comments:

  1. I am actually grateful to the holder of this web page who has shared
    this wonderful piece of writing at here.
    Flex developer London

    ReplyDelete
  2. Hi, i think that i saw you visited my web site thus i came to “return the favor”.I am attempting to find things to improve my web site!I suppose its ok to use a few of your ideas!!

    Flash developer London

    ReplyDelete