The following line resets the Identity value for the table so that the next record added starts at your specified seed value.
DBCC CHECKIDENT (yourtable, RESEED, reseedvalue)--For ExampleDBCC CHECKIDENT(' MyTestTable', RESEED, 0)
Either you have to delete all the records already existing in the table or else the Rseed Value should be greater than the max. of already existing values.
0 comments:
Post a Comment