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

  • February 27, 2013 at 12:46 pm

    #1591696

    Cadavre (2/27/2013)

    Read up on XACT_ABORT. XACT_ABORT is by default set to OFF in most instances for code in SQL Server, but inside a trigger it is set to ON by default.

    thanks Cadavre however I have tried setting SET XACT_ABORT OFF in the trigger as well as in the SProc