sqlserver_procesy.sql

select
convert(varchar(10),db_name(dbid)) as DBName
,    P.spid
,   right(convert(varchar, 
            dateadd(ms, datediff(ms, P.last_batch, getdate()), '1900-01-01'), 
            121), 12) as 'batch_duration'
,   P.program_name
, P.cmd
, p.open_tran
, p.status
,   P.hostname
,   P.loginame
from master.dbo.sysprocesses P
where P.hostname='slchap12'

order by batch_duration desc