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

26.4.1.Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values
26.4.2.Clearing Out Memory
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