Assuming that the self-increment is 65535, it has now arrived, and the 500,000 records before, can you use these empty ID numbers?
-------------------------------------------------- -------------
DBCC CHECKIDENT (Table, Reseed, 0);
-------------------------------------------------- -------------
Talent in the afternoon: DBCC Checkident (yourtable, reseed, 0)
Number starts from the new