sysservers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
srvid smallint 2 √ null
srvstatus smallint 2 √ null
srvname sysname 256 null
srvproduct sysname 256 null
providername nvarchar 256 null
datasource nvarchar 8000 √ null
location nvarchar 8000 √ null
providerstring nvarchar 8000 √ null
schemadate datetime 16,3 null
topologyx int 4 √ null
topologyy int 4 √ null
catalog sysname 256 √ null
srvcollation sysname 256 √ null
connecttimeout int 4 √ null
querytimeout int 4 √ null
srvnetname char 30 √ null
isremote bit 1 √ null
rpc bit 1 null
pub bit 1 null
sub bit 1 √ null
dist bit 1 √ null
dpub bit 1 √ null
rpcout bit 1 null
dataaccess bit 1 null
collationcompatible bit 1 null
system bit 1 null
useremotecollation bit 1 null
lazyschemavalidation bit 1 null
collation sysname 256 √ null
nonsqlsub bit 1 √ null

Relationships