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)

 

SQL SERVER – DBCC COMMANDS Category

What are DBCC Commands?

The DBCC commands acts as a Database Console commands for SQL Server. The DBCC commands are categorized into four.

 

Command Category Purpose
Maintenance Maintenance task on database,index & Filegroups
Miscellaneous* Miscellaneous tasks such as enabling trace flags or disabling a DLL from memory
Informational Task that gather and display various types of information.
Validation Validation Operation on database,table,index, filegroup or allocation of database pages.

The DBCC commands and examples will be continued.