DBCC « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. DBCC
26.4.DBCC
26.4.1.Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values
26.4.2.Clearing Out Memory
26.4.3.DBCC TRACEON
26.4.4.DBCC SHOW STATISTICS (tablename, index_name)
26.4.5.dynamically building the DBCC command:
26.4.6.Displaying the Oldest Active Transaction with DBCC OPENTRAN and Viewing Lock Activity
26.4.7.Syntax for Retrieving the Current IDENTITY Value of a Table and the Correct Value
26.4.8.Reseeding the IDENTITY Value
26.4.9.Syntax for Reseeding the IDENTITY Value with a New Explicit Value








26.4.10.Flushing the Procedure Cache