begin tran
select * from sys.dm_tran_active_transactions a
 join sys.dm_tran_session_transactions s
    on s.transaction_id = a.transaction_id
    and s.session_id = @@spid
commit tran