Hello Steve,

Please clarify my following concern about this question..

Why not DBCC CHECKIDENT?

Checks the current identity value for the specified table and, if needed, corrects the identity value.

Reference : http://msdn.microsoft.com/en-us/library/aa258817(v=sql.80).aspx

Regards,

K.K.Karuppusamy