Checks the current identity value for the specified table and, if needed, corrects the identity value.
Syntax:
DBCC CHECKIDENT ( 'table_name' [ , { NORESEED { RESEED [ , new_reseed_value ] } } ] )
Example:
This example forces the current identity value in the jobs table to a value of 30.
USE pubsGO DBCC CHECKIDENT (jobs, RESEED, 30)GO
