Using DML Triggers That Include COMMIT or ROLLBACK TRANSACTION

If triggers that include ROLLBACK TRANSACTION statements are fired from within a user-defined transaction, ROLLBACK TRANSACTION rolls back the whole transaction. In the following example, if the INSERT statement fires a trigger that includes ROLLBACK ...

technet.microsoft.com