SrcName (10/3/2013)

---

create table #temp

(

spid smallint ,

ecid smallint ,

status nchar(30) ,

loginame nchar(128) ,

hostname nchar(128) ,

blk char(5) ,

dbname nchar(128) ,

cmd nchar(16),

request_id int

)

insert into #temp exec sp_who

select * from #temp where blk!=0 order by cast(blk as int) desc