| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sysservers (Transact-SQL) |
sys.sysservers (Transact-SQL) |
rwestMSFT |
randolphwest |
03/15/2017 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
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)