Setting or changing next Auto Increment(Identity Seed) value

After my last post I got a few mails asking me how to reset the Auto Increment ID, or how to set the next ID to a certain value.

Well, here you go:

1. Open up SQL Enterprise/SQL Server Manager
2. Open the relevant database
3. Right click on the relevant table and choose ‘Modify’
4. Select the auto increment / identity column
5. Find the Identification Specification option and expand
   1. Now you can change the Identity seed to the desired value(remember to make it more than the MAX of that column of the current data)