This questions is in regards to how ASE "decides" which trigger on a
given table will be executed first? Is there a way to define trigger
order? Do compiled triggers reside in the procedure cache?
1. A single table has 2 independent insert triggers.
2. The insert triggers are defined on the table.
The order is random because a trigger is probably a specialized type of
stored procedure that becomes queued in procedure cache (FIFO).
Your input will be greatly appreciated.
Sent via Deja.com http://www.deja.com/
Before you buy.