If you work with tables used for heavy loads, with identity columns, you may need to reset the identity columns after a certain time.
Here is a script to perform that:

DBCC CHECKIDENT ('TableName', RESEED, 1)