sys.sysservers (Transact-SQL)
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 SQL Server 2000 System Tables to SQL Server 2005 System Views. 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.
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 |