Hmmz te lui om zelf even de manual er bij te pakken nu je weet waarnaar je moet zoeken.
DBCC CHECKIDENT (T-SQL)
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]} }]
)
Arguments
'table_name'
Is the name of the table for which to check the current identity value. Table names must conform to the rules for identifiers. For more information, see Using Identifiers. The table specified must contain an identity column.
NORESEED
Specifies that the current identity value should not be corrected.
RESEED
Specifies that the current identity value should be corrected.
new_reseed_value
Is the value to use in reseeding the identity column.
Remarks
If necessary, DBCC CHECKIDENT corrects the current identity value for a column. The current identity value is not corrected, however, if the identity column was created with the NOT FOR REPLICATION clause (in either the CREATE TABLE or ALTER TABLE statement).
Invalid identity information can cause message 2627 when a primary key or unique key constraint exists on the identity column.
The specific corrections made to the current identity value depend on the parameter specifications
ik denk dat er niets anders op zit dan 'n droptable en 'm opnieuw aanmaken..