• Hi,

    There is one subtle issue with the explanation (and also the MS documentation).

    It is not the ROLLBACK that is causing the abort of the batch. Instead, the batch is aborted if there is no transaction alive after the end of the trigger (at least that's what I can see from my tests).

    For example, adding a BEGIN TRAN right after the ROLLBACK TRAN ensures that the batch is not aborted.

    Best Regards,

    Chris Büttner