SP: Reset List Item ID in sharepoint Using SQL

-- http://www.sharepointlovers.com/reset-list-item-id-in-sharepoint-using-sql/
USE WSS_Content_BHB_sites_BedTracker;

-- check current values
SELECT * FROM WSS_Content_BHB_sites_BedTracker.[dbo].[AllListsAux] WHERE ListID='7569e012-d0c3-41f3-813f-a45c4061c1f9'

-- set id next val
UPDATE WSS_Content_BHB_sites_BedTracker.[dbo].[AllListsAux]
SET NextAvailableId = 1
WHERE ListID='7569e012-d0c3-41f3-813f-a45c4061c1f9';