Shashika Hettiarachchi : Techno Diary

 Use the following script to reset the ID to 0 DBCC CHECKIDENT ( TabaleName , RESEED, 0) -------------------------------- Regards Shashika --------------------------------------

How to Reset the List Item ID value numbering at 1 One of the most common problems we in SharePoint lists , there  is no direct way , the value of the ListItem ID reset. In development  environment we used to insert and delete a lot of records and during this time  ID value automatically increases as the ID column is an up counter type.  Finally , when we move to staging and production environments, the website with  backup and restore the ListItem -ID value will not start with 1 . One way of preventing this problem is update the content Database ListID value to 1 Get The specific content database Name Go To the Central Admin Application Management Click on Manage Content Database            Select the specific web Application Database Name will be shown Get The specific List ID (GUID) Method A 1.        Navigate to the list and click  ...