navigation
 Sunday, March 22, 2009
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
posted on March 22, 2009  #    by John Waters  Comments [0]
Related posts:
Discovering MARS
T-SQL: Drop All Objects in a SQL Server Database
T-SQL: How To Obtain SCOPE_IDENTITY() From an Object With an INSTEAD OF INSERT Trigger
T-SQL: A Simple Way to Build a String from a Column
T-SQL: How to Invert a Bit
Get More Out of Your Foreign Keys

Copyright © 2003-2010 Falafel Software Inc.