Active Transaction in SQL Server?

What is Active Transaction in SQL Server and Is there any T-SQL command or function available to check active transactions in SQL Server Database ?

Do you mean open transactions i.e. ones that have not been committed? You can use the following to find the oldest



You should also be able to query sys.dm_tran_active_transactions

1 Like

Thanks Dohsan for your helpful link and suggestion.