Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Patrick LeBlanc Deadlock Notifications in SQL Server 2005 RE: Deadlock Notifications in SQL Server 2005
DBA_Rob
Default port
Points: 1494
More actions
October 10, 2007 at 7:18 am
#740783
I haven't tried it yet, but could you also set up an Alert in SQL Server 2005 where the Object is SQL Server:Locks and the Counter is Number of Deadlocks/sec with a condition of if rises above 0. Then you could subsrcibe to the Alert?