Thank you Pedro, a useful and informative article.  The sections on the Abstraction, Expand and Contract, and Feature Toggles patterns are particularly interesting.  I am, however, surprised by your statement: "Trunk-Based...

I know it's a bit late (the thread was opened in 2008!), but here is the answer:

SELECT transaction_id FROM sys.dm_tran_current_transaction;