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.