Export (0) Print
Expand All

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 noteImportant

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft