Skip to content Skip to sidebar Skip to footer
Home / Sql Server / Sql Server 2005

Sql Server 2005 : Map Transaction_id To @@spid

Post a Comment
Is there anyway to map transaction_id from somewhere like sys.dm_tran_active_transactionsto an SPID in SQL Server 2005?

Solution 1:

It may sound obvious, but the first two columns documented for sys.dm_tran_session_transactions are session_id and transaction_id. This is the table that maps between transactions and sessions.


Post a Comment for "Sql Server 2005 : Map Transaction_id To @@spid"