Having the default setting to OFF basically break transactions and is a *bug* in SQL Server.

Explicit transactions should be exactly that, explicit. This stupidity is exactly the kind of thing that will cause nearly untraceable bugs in code. What were they thinking?

However, kudos for pointing this out, at least now it won't catch me...

Member of SPCP -- Society for the Prevention of Cruelty to Programmers