syslogins

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

suid

int

4

No

2

status

smallint

2

No

3

accdate

datetime

8

No

4

totcpu

int

4

No

5

totio

int

4

No

6

spacelimit

int

4

No

7

timelimit

int

4

No

8

resultlimit

int

4

No

9

dbname

sysname

30

Yes

10

name

sysname

30

No

11

password

varbinary

30

Yes

12

language

varchar

30

Yes

13

pwdate

datetimn

8

Yes

14

audflags

int

4

Yes

15

fullname

varchar

30

Yes

16

srvname

varchar

30

Yes

17

logincount

smallint

2

Yes

18

procid

int

4

Yes

Name

Attributes

Segment

Columns

syslogins

unique
clustered

system

suid

ncsyslogins

unique

system

name

#

Columns

1

suid

1

sp_commonkey references table sysprocesses.
Column suid to sysprocesses.suid

1

sp_commonkey coming from table sysdatabases.
sysdatabases.suid to column suid

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

0x07B7FE

dbo

2

sso_role

grant

select

All

dbo