Just tested. Delete Rules maintain context of the instance being deleted. Also, when used in a Process, the process does indeed "Pause" (good), and then executes the Delete Rules, and then returns to the Process with the next command after the DELETE BO
I then do a COMMIT TRANSACTION to force any outstanding saves, (thanks Rennur!). I do this because the COMMIT forces to the database to be in a "stable" state, in case you then want to EXEC any stored procs after the delete, to do any "post processing". I am a SQL Server and T-SQL wizard, so free to hit me up with SQL Server coding questions. As we all know, SQL Server is the best database known to mankind 🙂
Dave