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)

written by Arné

Other related PulseBlog posts:

• Can open To-Do list items, but Blank Forms don’t open
• Linux expeditions
• Don’t use “POST” forms if you wanna get crawled
• Google Analytics Benchmarks
• Another busy week - My Lif(v)e Update