The following TSQL statement will modify the employees table and set the LAST used seed value for the identity column on the table to 99. The result, the next insert to the employees table will create a record with an identity value of 100.
DBCC CHECKIDENT(‘Employees’,RESEED, 99)
