| title | sys.sysservers (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | d02f186f-c00f-44a6-b38d-dc78a3d2145b | ||||
| author | rothja | ||||
| ms.author | jroth |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Contains one row for each server that an instance of [!INCLUDEssNoVersion] can access as an OLE DB data source.
Important
[!INCLUDEssnoteCompView]
| Column name | Data type | Description |
|---|---|---|
| srvid | smallint | ID (for local use only) of the remote server. |
| srvstatus | smallint | [!INCLUDEssInternalOnly] |
| srvname | sysname | Name of the server. |
| srvproduct | sysname | Product name for the remote server. |
| providername | nvarchar(128) | OLE DB provider name for access to this server. |
| datasource | nvarchar(4000) | OLE DB data source value. |
| location | nvarchar(4000) | OLE DB location value. |
| providerstring | nvarchar(4000) | OLE DB provider string value. |
| schemadate | datetime | Date this row was last updated. |
| topologyx | int | Not used. |
| topologyy | int | Not used. |
| catalog | sysname | Catalog that is used when a connection is made to an OLE DB provider. |
| srvcollation | sysname | The collation of the server. |
| connecttimeout | int | Time-out setting for the server-connection. |
| querytimeout | int | Time-out setting for queries against the server. |
| srvnetname | char(30) | [!INCLUDEssInternalOnly] |
| isremote | bit | 1 = Server is a remote server. 0 = Server is a linked server. |
| rpc | bit | 1 = sp_serveroption@rpc set to true or on. 0 = sp_serveroption@rpc set to false or off. |
| pub | bit | 1 = sp_serveroption@pub set to true or on. 0 = sp_serveroption@pub set to false or off. |
| sub | bit | 1 = sp_serveroption@sub set to true or on. 0 = sp_serveroption@sub set to false or off. |
| dist | bit | 1 = sp_serveroption@dist set to true or on. 0 = sp_serveroption@dist set to false or off. |
| dpub | bit | 1 = sp_serveroption@dpub set to true or on. 0 = sp_serveroption@dpub set to false or off. |
| rpcout | bit | 1 = sp_serveroption@rpc out set to true or on. 0 = sp_serveroption@rpc out set to false or off. |
| dataaccess | bit | 1 = sp_serveroption@data access set to true or on. 0 = sp_serveroption@data access set to false or off. |
| collationcompatible | bit | 1 = sp_serveroption@collation compatible set to true or on. 0 = sp_serveroption@collation compatible set to false or off. |
| system | bit | 1 = sp_serveroption@system set to true or on. 0 = sp_serveroption@system set to false or off. |
| useremotecollation | bit | 1 = sp_serveroption@remote collation set to true or on. 0 = sp_serveroption@remote collation set to false or off. |
| lazyschemavalidation | bit | 1 = sp_serveroption@lazy schema validation set to true or on. 0 = sp_serveroption@lazy schema validation set to false or off. |
| collation | sysname | Server collation as set by sp_serveroption@collation name. |
| nonsqlsub | bit | 0 = server is an instance of [!INCLUDEssNoVersion] 1 = server is not an instance of [!INCLUDEssNoVersion] |
Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)