InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 05:49:14 GMT20http://www.sqlservercentral.com/Forums/Topic628399-473-1.aspxIs 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.ThanksThu, 08 Jan 2009 15:44:08 GMTYSLGuruhttp://www.sqlservercentral.com/Forums/Topic628399-473-1.aspx[font="Arial"]I've been using the following which provides similiar information.[/font]ALTER proc [dbo].[sp_blocking]asdeclare @spid intselect @spid=sy1.spidfrom master.dbo.sysprocesses sy1(nolock)join master.dbo.sysprocesses sy2(nolock) on sy1.blocked=sy2.spid and sy2.blocked=0where sy1.blocked!=0SELECT sy1.spid, sy1.status, sy1.hostname, sy1.program_name, sy1.cmd, sy1.blocked, sy1.dbid, convert(sysname, rtrim(sy1.loginame)) as loginnamefrom master.dbo.sysprocesses sy1(nolock)where sy1.spid=@spiddbcc inputbuffer(@spid)Thu, 08 Jan 2009 02:50:20 GMTdave.morrow-584993http://www.sqlservercentral.com/Forums/Topic628399-473-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Blocking./65384/">Complete Blocking Report</A>[/B]Thu, 01 Jan 2009 04:27:27 GMTVee