Is there anyway to map transaction_id from somewhere like sys.dm_tran_active_transactionsto an SPID in SQL Server 2005?
Asked
Active
Viewed 2,877 times
3
-
1[`sys.dm_tran_session_transactions`](http://msdn.microsoft.com/en-us/library/ms188739(v=sql.90).aspx)? – Damien_The_Unbeliever Oct 03 '12 at 07:24
-
Yep, that'll do it. Thanks. Do you want to put it as an answer? – Greg Oct 03 '12 at 07:29
1 Answers
5
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.
Damien_The_Unbeliever
- 234,701
- 27
- 340
- 448