set nocount on drop table #boso create table #boso ( spid nvarchar(max), ecid nvarchar(max), status nvarchar(max), loginame nvarchar(max), hostname nvarchar(max), blk nvarchar(max), dbname nvarchar(max), cmd nvarchar(max), request_id nvarchar(max) ) insert #boso exec sp_who select * from #boso where dbname = 'ITPORTAL_FALCONE' order by status