sysservers

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

srvid

smallint

2

No

2

srvstatus

smallint

2

No

3

srvname

varchar

30

No

4

srvnetname

varchar

32

No

5

srvclass

smallint

2

Yes

6

srvsecmech

varchar

30

Yes

7

srvcost

smallint

2

Yes

Name

Attributes

Segment

Columns

csysservers

unique
clustered

default

srvid

ncsysservers

unique

default

srvname

#

Columns

1

srvid

1

sp_commonkey references table sysremotelogins.
Column srvid to sysremotelogins.remoteserverid

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo