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 – How to Start the SQL Server in Minimal Configuration GUI

To Start SQL Server in minimum configuration mode, we need to do the following.

Start-> All Programs -> SQL Server 2012 -> SQL Server Configuration Manager.

In Configuration manager window, we need to select corresponding SQL Server services, if multiple instances are there, Here SQL Server services

Right click on SQL Server services and choose properties -> Startup Parameters -> Add “-m” to the startup paramerters and Add it.

Please have a look at the below image.

Start SQL Server in Minimal Config Mode

 

Note:

In Minimal mode, SQL Server is started in Single User Mode.