Post reply

Complete Blocking Report

  • January 1, 2009 at 4:27 am

    #217044

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

  • January 8, 2009 at 2:50 am

    #923159

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

  • January 8, 2009 at 3:44 pm

    #923793

    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 2 (of 2 total)

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