sql server reseed identity column
DBCC CHECKIDENT ('youtable', RESEED, <new seed value>)
Source: www.databasejournal.com
reseed sql identity
Reseed Ident SQL
DBCC CHECKIDENT ('youtable', RESEED, <new seed value>)
Reseed Ident SQL