Home Forums Article Discussions Article Discussions by Author Discuss content posted by integer Script to kill the top blocker and report what it was doing. RE: Script to kill the top blocker and report what it was doing.

  • October 27, 2010 at 2:21 pm

    #1243179

    I added the max expression and fix it.

    AND (select max(datediff(ss,last_batch,getdate()) ) FROM sysprocesses where blocked = @blocker) > 5