So that means that when xact_abort is set to off then

BEGIN TRANSACTION

...

COMMIT TRANSACTION

does not do as expected.

What's the default setting on a fresh install of SQL?