Go Back

Which transactions are running on my SQL server?

Yesterday I was debugging some SQL Server transaction logic, and came across the following handy command to see which transactions are running:

SELECT * 
FROM sys.dm_tran_session_transactions
  • Facebook
  • Twitter
  • DZone It!
  • Digg It!
  • StumbleUpon
  • Technorati
  • Del.icio.us
  • NewsVine
  • Reddit
  • Blinklist
  • Add diigo bookmark
Post a comment!
  1. Formatting options