To expand on my previous reply, this is what I meant

http://www.eggheadcafe.com/software/aspnet/31611992/update-insert-delete-trig.aspx

>I have a table that has both an update and delete trigger. The delete trigger actually updates data in the table, causing the update trigger to fire. Can I prevent the update trigger from firing when the update is made by the delete trigger?
>
>TIA
>
>John