Renumber Identity Fields

ksafford · September 15th, 2004, 02:48 PM

I have done this before, but I cannot remember how to reset an Identity field in a table. For example, I want the next record inserted to have an ID of 130,000. Please point me in the right direction.
Thank you.
Keith

happygv · September 15th, 2004, 09:07 PM

Here you go...

Code:

DBCC CHECKIDENT (TableName, RESEED, 130000)

Cheers!

_________________________
- Vijay G
Strive for Perfection

Anantsharma · September 30th, 2004, 05:20 AM

Happy is correct but be carefull to RESEED with one less value
After insertion it will come to correct.

If u want next row with ID=200, u should use RESEED with 199.

Hey u should also see SET Identity_Insert.

B. Anant