Thanks, Cringer.
I'll try to use the correct transaction scoping as you described in your example. However, I was also looking for a way how to create the DELETE trigger, so that when someone later adds a code where he makes some changes to the Orders table, the trigger would still work in all...