We have an COM+ routine which deletes the unwanted data from the database. Three tables involved in this operation two master table and one child table which has the primary key for the two master tables ( join).
Is there a way the RI point to invalid rows in any of the master tables when the deletion of records failed?. Because we have a very huge volume of data and some time our COM+ routine fails to delete from either of master table.

Advise me.