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). |