Neil Thomas (5/23/2012)
So that means that when xact_abort is set to off thenBEGIN TRANSACTION
...
COMMIT TRANSACTION
does not do as expected.
What's the default setting on a fresh install of SQL?
Ah, an additional comment has been added whilst I wrote this.
That's a bit of a gotcha isn't it?