sysprocesses

select case rtrim(status) when 'background' then '0bg' when 'runnable' then '9run' when 'sleeping' then '2sleep' when 'suspended' then '8suspend' else rtrim(status) end as status,
 spid, kpid, blocked, open_tran, rtrim(upper(hostname)) as hostname, rtrim(cmd) as cmd, db_name(dbid) as dbname, cpu, physical_io, waittime, lastwaittype,
 rtrim(waitresource) as waitresource, rtrim(loginame) as loginame, rtrim(program_name) as prg, sql_handle, 'dbcc inputbuffer('+cast(spid as varchar)+')' as i
from master..sysprocesses with(nolock) where (open_tran <> 0 or blocked <> 0) or spid in (select distinct blocked from master..sysprocesses with(nolock)
where blocked <> 0) or rtrim(status) = 'runnable' or rtrim(cmd) not in ('AWAITING COMMAND', 'MISCELLANEOUS')
order by status desc, cpu desc, physical_io desc, waittime desc