@peter , i am also seeing the same issue , any chance of more details what you did to resolve this ? or full sql stored proc ? did u modify the oldsubmissions proc ? we had issue with orginal proc orphaning UFRecordFields , so did u have the same issues . Andy

ps. if you want to check for orphaned files

 select * from UFRecordFields where Record not in (select id from UFRecords)

Just in case your getting them too.

I just updated procedure from this example: http://siempresolutions.co.uk/blog/DeletingOldUmbracoFormSubmissions

 CREATE PROCEDURE dbo.Umbraco8Db
    @Days int = 2000
AS

BEGIN
    DECLARE @DeleteDate AS DateTime
    SET @DeleteDate = DATEADD(DAY, -@Days, GETDATE())
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    ALTER TABLE dbo.[UFRecordFields] NOCHECK CONSTRAINT ALL
    ---hack for umbraco8 forms, different DELETE_RULE as in umbraco6 forms
    print 'start';
    -- databit
    DELETE db
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataBit] AS db ON rf.[Key] = db.[Key]
    WHERE r.[Updated] < @DeleteDate;
        print 'databite';
    -- datetime
    DELETE dt
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataDateTime] AS dt ON rf.[Key] = dt.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'datetime';
    -- integer
    DELETE di
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataInteger] AS di ON rf.[Key] = di.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'integer';
    -- longstring
    DELETE dls
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataLongString] AS dls ON rf.[Key] = dls.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'longstring';
    -- string
    DELETE ds
    FROM dbo.[UFRecords] AS r 
   INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataString] AS ds ON rf.[Key] = ds.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'string';
    -- finally the record
    DELETE r    
    FROM dbo.[UFRecords] AS r 
    WHERE r.[Updated] < @DeleteDate;
    print 'final';
END
GO

Update for Umbraco 12

USE [dbname]
GO
/****** Object:  StoredProcedure [dbo].[procedurename]    Script Date: 2023-12-14 13:10:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[procedurename]
    @Days int = 180
AS
--EXEC sp_fkeys @pktable_name = 'UFRecordFields', @pktable_owner = 'dbo' 
--show all dependencies
BEGIN
    DECLARE @DeleteDate AS DateTime
    SET @DeleteDate = DATEADD(DAY, -@Days, GETDATE())
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    ALTER TABLE dbo.[UFRecordFields] NOCHECK CONSTRAINT ALL
    ALTER TABLE dbo.[UFRecordAudit] NOCHECK CONSTRAINT ALL
    ---hack for umbraco8 forms, different DELETE_RULE as in umbraco6 forms
    print 'start';
    -- SELECT @DeleteDate; 
    -- databit
    DELETE db
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataBit] AS db ON rf.[Key] = db.[Key]
    WHERE r.[Updated] < @DeleteDate;
        print 'databite';
    -- datetime
    DELETE dt
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataDateTime] AS dt ON rf.[Key] = dt.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'datetime';
    -- integer
    DELETE di
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataInteger] AS di ON rf.[Key] = di.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'integer';
    -- longstring
    DELETE dls
    FROM dbo.[UFRecords] AS r 
    INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataLongString] AS dls ON rf.[Key] = dls.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'longstring';
    -- string
    DELETE ds
    FROM dbo.[UFRecords] AS r 
   INNER JOIN dbo.[UFRecordFields]     AS rf ON r.[Id] = rf.[Record]
    INNER JOIN dbo.[UFRecordDataString] AS ds ON rf.[Key] = ds.[Key]
    WHERE r.[Updated] < @DeleteDate;
    print 'string';
    -- finally the record
    DELETE r    
    FROM dbo.[UFRecords] AS r 
    WHERE r.[Updated] < @DeleteDate;
    print 'final';
END

Add ALTER TABLE dbo.[UFRecordAudit] NOCHECK CONSTRAINT ALL to solve problem with conflict like this.

The DELETE statement conflicted with the REFERENCE constraint "FKUFRecordAuditUFRecords_Id". The conflict occurred in database "B365WebUmbProd", table "dbo.UFRecordAudit", column 'Record'.

is working on a reply...