Keep in mind - the various methods mentioned aren't necessarily contradictory/ or exclusive. In cases where DRI is paramount for me, and I want to make SURE I don't have a bad day and leave some orphans behind, I implement the confirmation pieces in the UI, with the cleanup process AND the cascade delete.
Just be sure to envision ALL of the deletes and WHERE it will cascade to. Nothing quite like putting a cascade delete on a self-joining reference: you could wipe out the entire company table on a single person delete......:w00t:
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?