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.
PaulusTandang
Grasshopper
Points: 22
More actions
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