Error!
Success!

Immediate deadlock notifications without changing existing code

0
kicks

Immediate deadlock notifications without changing existing code  (Unpublished)

In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error. The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and it doesn't work for non stored procedure code. And that IS a pretty BIG con! So here's a solution to this con.


Kicked By:
Drop Kicked By: