syslocks

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

id

int

4

No

2

dbid

smallint

2

No

3

page

int

4

No

4

type

smallint

2

No

5

spid

smallint

2

No

6

class

varchar

30

Yes

7

fid

smallint

2

Yes

8

context

tinyint

1

Yes

9

row

smallint

2

Yes

10

loid

int

4

Yes

1

sp_commonkey references table sysprocesses.
Column spid to sysprocesses.spid

1

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

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo