How to reseed an ID autoincrement column in Microsoft SQL Server
If a table has been copied from one database to another, or the ID autoincrement column needs to be switched off for identity row insert, you can reseed the ID column to increment from a defined value.