Home Forums SQL Server 2008 T-SQL (SS2K8) Is a doomed transaction inevitable if deadlock occurs in a trigger (SQL Server 2008 R2)? RE: Is a doomed transaction inevitable if deadlock occurs in a trigger (SQL Server 2008 R2)?

  • Maybe you should take a look at Service Broker architecture if deadlocks are a big problem? All changes will be applied sequentially?

    Alternatively try to understand why they occur.