[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)