sys.sysservers (Transact-SQL)

 

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

System_CAPS_ICON_important.jpg 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 nameData typeDescription
srvidsmallintID (for local use only) of the remote server.
srvstatussmallintIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed.
srvnamesysnameName of the server.
srvproductsysnameProduct name for the remote server.
providernamenvarchar(128)OLE DB provider name for access to this server.
datasourcenvarchar(4000)OLE DB data source value.
locationnvarchar(4000)OLE DB location value.
providerstringnvarchar(4000)OLE DB provider string value.
schemadatedatetimeDate this row was last updated.
topologyxintNot used.
topologyyintNot used.
catalogsysnameCatalog that is used when a connection is made to an OLE DB provider.
srvcollationsysnameThe collation of the server.
connecttimeoutintTime-out setting for the server-connection.
querytimeoutintTime-out setting for queries against the server.
srvnetnamechar(30)Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
isremotebit1 = Server is a remote server.

0 = Server is a linked server.
rpcbit1 = sp_serveroption@rpc set to true or on.

0 = sp_serveroption@rpc set to false or off.
pubbit1 = sp_serveroption@pub set to true or on.

0 = sp_serveroption@pub set to false or off.
subbit1 = sp_serveroption@sub set to true or on.

0 = sp_serveroption@sub set to false or off.
distbit1 = sp_serveroption@dist set to true or on.

0 = sp_serveroption@dist set to false or off.
dpubbit1 = sp_serveroption@dpub set to true or on.

0 = sp_serveroption@dpub set to false or off.
rpcoutbit1 = sp_serveroption@rpc out set to true or on.

0 = sp_serveroption@rpc out set to false or off.
dataaccessbit1 = sp_serveroption@data access set to true or on.

0 = sp_serveroption@data access set to false or off.
collationcompatiblebit1 = sp_serveroption@collation compatible set to true or on.

0 = sp_serveroption@collation compatible set to false or off.
systembit1 = sp_serveroption@system set to true or on.

0 = sp_serveroption@system set to false or off.
useremotecollationbit1 = sp_serveroption@remote collation set to true or on.

0 = sp_serveroption@remote collation set to false or off.
lazyschemavalidationbit1 = sp_serveroption@lazy schema validation set to true or on.

0 = sp_serveroption@lazy schema validation set to false or off.
collationsysnameServer collation as set by sp_serveroption@collation name.
nonsqlsubbit0 = server is an instance of SQL Server

1 = server is not an instance of SQL Server

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

Community Additions

ADD
Show: