Stack Overflow
Stack Overflow

Questions tagged [dbcc]

DBCC stands for Database Console Commands in Transact-SQL.

The Database Console Commands (DBCC) are a series of statements in Transact-SQL programming language to check the physical and logical consistency of a Microsoft SQL Server database. These commands are also used to fix existing issues. They are also used for administration and file management.

DBCC was previously expanded as Database Consistency Checker.

Source: Wikipedia (Database Console Commands)

106 questions
-1
votes
1 answer

SQL Server: reset identity on any delete action

Let's take a simple example. There's a table named test: Now I'm gonna delete some data without reset the identity log: When I insert new data, the new id will be 7: I'd like that on every delete query the DBCC CHECKIDENT function was…
Keoma Borges
  • 683
  • 2
  • 12
  • 27
1 2 3 4 5 6 7
8