MemoSoup

select spid,cmd,status,loginame,open_tran,
  datediff (s,last_batch,getdate()) as [Waittime (s)]
from master..sysprocesses p
where open_tran > 0
           and spid > 50
          and datediff (s,last_batch,getdate()) > 30
          and exists ( select * from master..syslockinfo
                        [...]