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)?

  • March 10, 2013 at 5:31 pm

    #1595345

    siggemannen (3/10/2013)

    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.

    we cannot use server broker because the transaction is expected to be completed immediately; the UI queries the results right after the data is saved