Dec 6, 2022 · The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server.

After the DBCC CHECKDB command finishes, a message is written to the SQL Server error log. If the DBCC command successfully executes, the message indicates success and the amount …

Sep 3, 2024 · Checks the current identity value for the specified table in SQL Server and, if needed, changes the identity value. You can also use DBCC CHECKIDENT to manually set a …

Sep 18, 2025 · Learn how to set specific server characteristics or to alter a particular behavior in SQL Server, using DBCC TRACEON.

DBCC OPENTRAN displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the transaction log of the …

Sep 3, 2024 · After the DBCC CHECKTABLE command finishes, a message is written to the SQL Server error log. If the DBCC command successfully executes, the message indicates a …

Sep 3, 2024 · In Azure SQL Database, DBCC FREEPROCCACHE acts on the database engine instance hosting the current database or elastic pool. Executing DBCC FREEPROCCACHE in …

Sep 3, 2024 · SQL Server requires VIEW SERVER STATE permission on the server to run DBCC SQLPERF(LOGSPACE). To reset wait and latch statistics requires ALTER SERVER STATE …

Oct 10, 2025 · Use DBCC TRACEON only while users or applications aren't concurrently running statements on the system. Trace flags are used to customize certain characteristics by …

Sep 29, 2025 · Introduced in SQL Server 2022 (16.x), the shrink wait at low priority feature addresses this problem by taking a schema modify lock in WAIT_AT_LOW_PRIORITY mode.