SQL Server – DBCC COMMANDS (Information Statements)- DBCC OPENTRAN

DBCC OPENTRAN is used to identify the active transactions that may preventing the log truncation. DBCC OPENTRAN displays information about the oldest active transaction and oldest distributed and non distributed replicated transactions.

 

DBCC OPENTRAN(Table_name)