> Assumption #1: All transactions execute as stored procedures.
This kind of surprised me. Is that really a widespread assumption?
As an application developer I'm used to starting+committing transactions myself, outside the context of a stored procedure; I've done this with SQL Server and SQLite.