Mega Code Archive
Using DBCC CHECKIDENT to View and Correct IDENTITY Seed Values
DBCC CHECKIDENT checks the current maximum value for the specified table.
The syntax for this command is as follows:
DBCC CHECKIDENT
(
'table_name'
[ , {
NORESEED | { RESEED [ , new_reseed_value ] }
}
]
)
[ WITH NO_INFOMSGS ]
NORESEED NORESEED means that no action is taken other then to report the maximum identity value.
RESEED RESEED specifies what the current IDENTITY value should be.
new_reseed_value The new current IDENTITY value.
WITH NO_INFOMSGS WITH NO_INFOMSGS suppresses informational messages from the DBCC output.