How to check that there is transaction that is not yet committed in SQL Server 2005?

Question

Does anyone know the command to check if there is an un-committed transaction in SQL Server 2005?

question from:https://stackoverflow.com/questions/980143/how-to-check-that-there-is-transaction-that-is-not-yet-committed-in-sql-server-2

Answer 1

use @@trancount or sys.dm_tran_active_transactions DMV in sql 2005, 2008