>>Yes as long as update of both tables happen in the same transaction.
>
>If this is in reference to updating two tables within one update command, I do not have that. Each update is only applied to one table at a time. But, within the same hit, doing an update in the Monitor table, will by the same trigger an update in the Member table as this is always done at the end of the hit. So, if I understand correctly, the cause of this deadlock issue would be caused by something else.
If you're using automatic transaction than yes. If you're using manual transaction than I wouldn't know w/o seeing what is included in a transaction.
--sb--