How to check that there is transaction that is not yet committed in SQL Server 2005? July 23, 2023 by Tarik use @@trancount or sys.dm_tran_active_transactions DMV in sql 2005, 2008