• IgorMi, you have forgotten to add the unique index in your customized example.

    And yes, I have tried it. There is a huge difference between XACT_ABORT ON or OFF, and that is 0 rows versurs 3 rows (when you have the unique index in place)