how to reset an entire databases auto increment to 1 in sql code example Example: sql server reset auto increment DBCC CHECKIDENT (mytable, RESEED, 0)