Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Returns the list of linked servers defined in the local server.
Transact-SQL syntax conventions
Syntax
sp_linkedservers
[ ; ]
Arguments
None.
Return code values
0 (success) or a nonzero number (failure).
Result set
| 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. |
Permissions
Requires SELECT permission on the schema.
Related content
- sp_catalogs (Transact-SQL)
- sp_column_privileges (Transact-SQL)
- sp_columns_ex (Transact-SQL)
- sp_foreignkeys (Transact-SQL)
- sp_indexes (Transact-SQL)
- sp_primarykeys (Transact-SQL)
- sp_table_privileges (Transact-SQL)
- sp_tables_ex (Transact-SQL)
- System stored procedures (Transact-SQL)
- Distributed Queries stored procedures (Transact-SQL)