I was thinking that for most purposes, an explicit transaction would suffice.


BEGIN TRAN

DELETE statement

INSERT statement

COMMIT TRAN


Drew