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

  • davidsatz (2/28/2013)


    So I am not hearing anyone disagree with my conclusion that there is no way to accomplish this...:ermm:

    I do disagree, we have deadlock retry logic on our product. The logic works by passing the error number out from the trigger and into the sproc, then rolling back to the savepoint if XACT_STATE() <> -1 otherwise the transaction is doomed so rollback the entire transaction.


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/