Orphan links in Kentico - cannot delete objects
SQL to remove orphan links in Kentico DECLARE @nodeIdsToDelete TABLE (NodeID int) INSERT INTO @nodeIdsToDelete SELECT NodeID FROM CMS_Tree WHERE NodeID NOT IN (SELECT DocumentNodeId FROM CMS_Document) AND NodeLinkedNodeID IS NULL DELETE FROM ...