• Agree with the DELETE statement, would suggest to use BEGIN TRAN to be on a safe side and then COMMIT