>>Part of the reason I mention this is beause some developers write code in triggers on the assumption that INERTED and DELETED will only ever have one row.
>
>Good to know. Thanks.
>
>Also, the tables contains the data BEFORE the action occurs? So the Deleted table contains the row prior to being deleted, or after?
Both tables contain the data after the fact, however, you can issue Rollback in the trigger and then (I believe) you would be able to cancel the original operation (no update would happen).
If it's not broken, fix it until it is.
My Blog