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.