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