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

sqlsql-serversql-server-2005transactions

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

Best Solution

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