Steve,

so what your saying is that the DBCC Checkidentity command only resets what the ID will be of the next column that is inserted ... but does not actually change the ID on the columns that already exist?

if my understanding is correct, then if i drop and recreate the identity column with it assign an ID to the rows that already exist?

basically it seems like if i could "reorder" the identity column from zero again.

thanks

Leroy