Pasted

-- 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';