Re-seeding the Identity Value

dbcc checkident ([table to re-seed], reseed, [value to set identity value at])

If you set the value to 0, the next inserted value will be 1

dbcc checkident ([table to re-seed], reseed, [value to set identity value at]) If you set the value to 0, the next inserted value will be 1