An example is if you wanted to start numbering your ID column at 1000 instead of 1.
It would be wise to first check what the current identify value is.
(which it really shouldn’t)
DBCC CHECKIDENT ( ‘databasename.dbo.orders’,RESEED, 999)
Reset Identity Column Value in SQL Server
If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want.
