If you are using identity (auto increasment) column on your SQL Server tables,
you can reset identity value to 0 (Zero) or whatever value you want is very easy.

Below command set next insert value to 1 :

DBCC CHECKIDENT (TableName, RESEED, 0)

To set the value of the next ID to be 1000, You can use this command:

DBCC CHECKIDENT (TableName, RESEED, 999)

Comments