select transaction_id from sys.dm_tran_current_transaction;