You might remember Yaniv Etrogi's SQL Scripter toolkit that I wrote about back in November 2008. If you like that, then you'll probably enjoy adding Yaniv's newest scripts to your toolbox. This utility detects blocking locks on SQL Server 2005 and 2008, plus allows smtp notification and logging of the blocking event. If you have database concurrency issues, then be sure to check out the Freeware version at:
www.sqlserverutilities.com/download.htm
Cheers! -Kevin
P.S. Twitter at keklin
1 comment
Hide comments