Reset the Identity value of the table.

If you some how need to reset(reseed) the identity value of the table in mssql here is the code that will work for you.

dbcc checkident('table',reseed,new_reseed_value)

new_reseed_value should be the current last value of the identity value.

so new row will be new_reseed_value + 1.

more info about checkident you can read here:

http://msdn.microsoft.com/en-us/library/aa258817(SQL.80).aspx