Immediate deadlock notifications without changing existing code(weblogs.sqlteam.com)
submitted by 
spirit1(3160) 3 years, 10 months ago
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.
|category: Database
|Views: 20
tags:
SQLServer 2008 Database 2005 another
Everyones tags:
Your Tags: