[DUG] MSSQL Question

[Myles Penlington]

Neven, didn't you read the manuals on multiple triggers? - I presume
from your comment you do not have multiple triggers on the same table? 

You cannot really control the execution order (except for the first and
last trigger), and it is randomised on different db's. I find it seems
to rely on the DDL execution order in fact (but it does change with
further trigger DDL on the same table).

Myles.


I tend to make my databases transactional (with accruals in triggers) 
and then you a) dont really require transactions and b) eliminate the 
chances of a deadlock as the table update sequence is controlled
by the triggers and hence is consistent

Neven


Attention:
This communication is confidential and may be legally privileged.  If you are not the intended recipient, please do not use, disclose, copy or distribute it, other than to return it to us with your confirmation that it has been deleted from your system.