To reseed the identity value of a column you can use the DBCC CheckIdent command. In the following example I reseed the identity column of a table called ExampleTable to 9. The reseed value has to be one lower than what you actually want the new record to have. So if you want a new record to be inserted with a value of 10 you must reseed the column with a value of 9.