locked
Reset the ID counter of list items to 1 RRS feed

Answers

  • Hi,

    This is not a good practice this will remove the support of your environment from MSFT.

    You should not be suggesting this.

    If you want to reset the counter to 1 then save list as template without data and then delete the list and use the template to create a new list and you will have IDs starting from 1.

    I hope this will help you out


    Thanks, Rahul Rashu
    Friday, November 18, 2011 4:34 AM
  • It also totally violates licensing and means Microsoft probably won't help you if your deployment goes wrong, as you're accessing and changing the SharePoint databases directly.

    As a Microsoft Partner, this isn't the sort of thing you'd want to advocate in a production environment or a saleable solution.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, November 17, 2011 3:58 PM
    Answerer

All replies

  • It also totally violates licensing and means Microsoft probably won't help you if your deployment goes wrong, as you're accessing and changing the SharePoint databases directly.

    As a Microsoft Partner, this isn't the sort of thing you'd want to advocate in a production environment or a saleable solution.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/
    Thursday, November 17, 2011 3:58 PM
    Answerer
  • Hi,

    This is not a good practice this will remove the support of your environment from MSFT.

    You should not be suggesting this.

    If you want to reset the counter to 1 then save list as template without data and then delete the list and use the template to create a new list and you will have IDs starting from 1.

    I hope this will help you out


    Thanks, Rahul Rashu
    Friday, November 18, 2011 4:34 AM
  • Since there is not another way to reset the ID and keep the original list, would it make sense to delete all of the items from the list and reset the ID to 1 in the development system.  Then the backup/restore process would create the list in production with the correct ID.  This process would not be done in the production database, only dev.  Would that break the support contract?
    Wednesday, September 18, 2013 6:10 PM
  • Hi,

    This is not a good practice this will remove the support of your environment from MSFT.

    You should not be suggesting this.

    If you want to reset the counter to 1 then save list as template without data and then delete the list and use the template to create a new list and you will have IDs starting from 1.

    I hope this will help you out


    Thanks, Rahul Rashu

    Hi, everybody suggests doing the "Save List Template and recreate List using Template" solutions but it does not have the same effect, so it's not an alternative, IMHO.

    Imagine you have a lot of lists in this situation with a lot of List EventHandlers attached to it ? 
    The template is not going to re-attach the EventHandlers, so I think you should be more precise when pointing out solutions that should have the same effect with no side effect.

    I am going to test this in a DEV sandbox because I think it's VERY usefull and I don't have any support contract that might be broken.

    Cheers,

    Monday, March 17, 2014 10:27 AM