>Hi,
>
> Please, anybody knows how to control the order of execution of
>many triggers on the same table ?
> Example:
> I have this insert triggers:
> TR_TAB_INS_1
> TR_TAB_INS_2
> TR_TAB_INS_3
> How determine the order of fired is 3, 2 and finally 1 ?
>
>Thanks,
as Mike said the order is undetermined in SQL Server 7. You could nest them if you want a specific order fired. Of course, you would have to have your server configured to allow nested triggers.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao