sql server reset auto increment
snippet in sql

sql reset auto increment

user5761

ALTER TABLE tmp AUTO_INCREMENT = 3;

sql server reset auto increment

user3419

DBCC CHECKIDENT (mytable, RESEED, 0)