A Bundle of Changes

Nested Transactions

Steve Jones notes there aren't really nested transactions in SQL Server. And we all ought to know this.

Rethinking SQL Explicit Transactions

This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.

XACT_STATE(), @@TRANCOUNT and ROLLBACK

Explicit Transactions

There are frequent misunderstandings about Explicit Transactions, not limited to use of 'nested transactions'. This article attempts to explain by example many of the behaviors of this feature.