Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger - Order of Execution
Message
 
 
To
31/01/2001 13:23:17
Roberto Cysne
Banco do Nordeste S.A.
Fortaleza, Brazil
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00470799
Message ID:
00471290
Views:
19
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform