DELETE FROM schema1.table1;
DELETE FROM schema2.table2;
DELETE FROM schema3.table3;
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
Msg 50000, Level 16, State 1, Procedure tdel_Batches, Line 21
Deletes are not allowed as it will invalidate the Meta Vault AuditLog. You can disable the trigger at your own risk.
Msg 3609, Level 16, State 1, Line 11
The transaction ended in the trigger. The batch has been aborted.
The error seems to be in the triggers, so you should try disabling them in the tables that you want to delete data from:
sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER all';
If you want to enable them again afterwards, then you can do;
sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER all';