[DUG] MSSQL Question

[Neven MacEwan]

Myles

I'd only ever have 2 triggers, one for RI (which reads only, hence does 
not fire other triggers) and the other for Data updates (which only 
spans the same related tables as the RI trigger), yes I know that other 
than that you cannot control their execution order.

Cheers

N
> 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.
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at delphi.org.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
>
>
>