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
Close relationships within degrees of separation
