SQLTeam.com | Weblogs | Forums

Active Transaction in SQL Server?

tsql
sql2014

#1

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 ?


#2

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

DBCC OPENTRAN

BOL

You should also be able to query sys.dm_tran_active_transactions


#3

Thanks Dohsan for your helpful link and suggestion.