sys.sysservers (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Contains one row for each server that an instance of SQL Server can access as an OLE DB data source.

Important

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

Column name Data type Description
srvid smallint ID (for local use only) of the remote server.
srvstatus smallint Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
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) Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
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 SQL Server

1 = server is not an instance of SQL Server

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)