How to reset auto increment in msSQL Leave a reply Simply execute the following command: DBCC CHECKIDENT('TableNameHere', RESEED, 0);