Complete Blocking Report

  • Vee

    Hall of Fame

    Points: 3028

    Comments posted to this topic are about the item Complete Blocking Report

  • dave.morrow-584993

    SSC Journeyman

    Points: 97

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

  • YSLGuru

    SSC-Insane

    Points: 21304

    Is anyone else having problems getting to the page with the actual script/code? No matter how I try to navigate to it, everytime I get the 'Need to Register' page/pop-up and clicking the 'Log In' button just refreshes the page.

    Thanks

    Kindest Regards,

    Just say No to Facebook!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply