sp_linkedservers#
Returns a list of connections (aka. linked servers) accessible by the current user.
Syntax#
sp_linkedservers
Result Sets#
Column name |
Data type |
Description |
|---|---|---|
SRV_NAME |
sysname |
Name of the connection (linked server). |
SRV_PROVIDERNAME |
nvarchar(128) |
Provider name managing access to the specified connection (linked server). |
SRV_PRODUCT |
nvarchar(128) |
Product name of the linked server. |
SRV_DATASOURCE |
nvarchar(4000) |
Target source name. |
SRV_PROVIDERSTRING |
nvarchar(4000) |
Always null. |
SRV_LOCATION |
nvarchar(4000) |
Always null. |
SRV_CAT |
sysname |
Always null. |
Permissions#
Requires a VIEW CONNECTION permission.