sysservers (T-SQL)

Contains one row for each server that Microsoft® SQL Server™ can access as an OLE DB data source.

Column name Data type Description
srvid smallint ID (for local use only) of the remote server.
srvstatus smallint Bitmap of options.
srvname sysname Name of the server.
srvproduct nvarchar(128) 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 Used by the SQL Server Enterprise Manager server topology diagram.
topologyy int Used by the SQL Server Enterprise Manager server topology diagram.
catalog sysname Catalog that is used when making a connection to an OLE DB provider.
srvnetname char(30) Reserved (currently the same as the srvname).

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.