Reset autoincrement in Microsoft SQL

DBCC CHECKIDENT ("YourTableNameHere", RESEED, 1);