• I agree with some of the other posts that express frustration that this is the default setting that seems rather contrary to an explicit transaction.

    So the take away here is that whenever you need to declare an explicit transaction you should include SET XACT_ABORT ON before proceeding.

    I have to remember that one, thanks.