Tag Archives: SQL

MS SQL resetting the auto increment

Posted on May 5, 2010 by Wayne

DBCC CHECKIDENT(‘test’, RESEED, 10001) ; where ‘test’ is the tables name we want to reset. There is a trick if you already have some date into your table your next inserting will start from 0. I’ve tested this and it … Continue reading →