Great QOTD and discussion, especially on batch boundaries and ROLLBACK of nested transactions. I was unsure whether BEGIN TRAN was part of the batch, as well as the effect of that final COMMIT. This is one of those questions that it was better to get wrong. 🙂

Thanks, Kenneth!