Waiting Tasks

select a.spid,b.name,a.cmd,a.memusage,a.cpu,a.program_name,a.nt_username,a.loginame,a.hostname,a.status
from
master.dbo.sysprocesses a,master.dbo.sysdatabases b where a.dbid=b.dbid and
blocked<>0
go