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?

Answer 1

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