Skip to content

Instantly share code, notes, and snippets.

View eriksimonic's full-sized avatar

Erik Simonič eriksimonic

  • Business Solutions d.o.o.
  • Slovenia
View GitHub Profile
@eriksimonic
eriksimonic / DeleteAllVersions.sql
Last active October 23, 2016 10:41 — forked from Hendy/DeleteAllVersions.sql
Umbraco - delete version history for all content , Umbraco 7.5+
TRUNCATE TABLE umbracoLog
GO
TRUNCATE TABLE umbracoUser2NodePermission
GO
-- Create a temporary table for all documents which are published and not in the recycle bin
CREATE TABLE #Nodes (id int)
-- Delete all rows if the table exists before
TRUNCATE TABLE #Nodes