[font="Arial"]
I've been using the following which provides similiar information.
[/font]
ALTER proc [dbo].[sp_blocking]
as
declare @spid int
select @spid=sy1.spid
from master.dbo.sysprocesses sy1(nolock)
join master.dbo.sysprocesses sy2(nolock) on sy1.blocked=sy2.spid and sy2.blocked=0
where sy1.blocked!=0
SELECT
sy1.spid,
sy1.status,
sy1.hostname,
sy1.program_name,
sy1.cmd,
sy1.blocked,
sy1.dbid,
convert(sysname, rtrim(sy1.loginame)) as loginname
from master.dbo.sysprocesses sy1(nolock)
where sy1.spid=@spid
dbcc inputbuffer(@spid)