sysprocesses

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

spid

smallint

2

No

2

kpid

int

4

No

3

enginenum

int

4

No

4

status

char

12

No

5

suid

int

4

No

6

hostname

char

10

No

7

program_name

char

16

No

8

hostprocess

char

8

No

9

cmd

char

16

No

10

cpu

int

4

No

11

physical_io

int

4

No

12

memusage

int

4

No

13

blocked

smallint

2

No

14

dbid

smallint

2

No

15

uid

int

4

No

16

gid

int

4

No

17

tran_name

varchar

64

Yes

18

time_blocked

int

4

Yes

19

network_pktsz

int

4

Yes

20

fid

smallint

2

Yes

21

execlass

varchar

30

Yes

22

priority

varchar

10

Yes

23

affinity

varchar

30

Yes

24

id

int

4

Yes

25

stmtnum

int

4

Yes

26

linenum

int

4

Yes

27

origsuid

int

4

Yes

28

block_xloid

int

4

Yes

29

clientname

varchar

30

Yes

30

clienthostname

varchar

30

Yes

31

clientapplname

varchar

30

Yes

32

sys_id

smallint

2

Yes

33

ses_id

int

4

Yes

34

loggedindatetime

datetime

8

Yes

35

ipaddr

varchar

15

Yes

1

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

2

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

3

sp_commonkey coming from table syslocks.
syslocks.spid to column spid

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo