1     create table #who1result(-- 0 Rows, Data: 0 B, Index: 0 B
2         fid smallint not null,
3         spid smallint not null,
4         status char(12) not null,
5         loginame char(- 1) not null,
6         origname char(- 1) not null,
7         hostname varchar(30) not null,
8         blk_spid smallint not null,
9         dbname char(- 1) not null,
10        tempdbname char(- 1) not null,
11        cmd varchar(30) not null,
12        block_xloid int not null,
13        affinity varchar(30) not null
14    )
15    

DEPENDENCIES

READERS AND WRITERS written by proc sybsystemprocs..sp_who