Very Computer

> 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?

> Assumptions:
> 1.  A single table has 2 independent insert triggers.
> 2.  The insert triggers are defined on the table.

> My Guess:
> The order is random because a trigger is probably a specialized type of
> stored procedure that becomes queued in procedure cache (FIFO).

>Assumptions:
>1.  A single table has 2 independent insert triggers.
>2.  The insert triggers are defined on the table.

>My Guess:
>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.
>Scott

>Sent via Deja.com http://www.deja.com/
>Before you buy.

> 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?

> Assumptions:
> 1.  A single table has 2 independent insert triggers.
> 2.  The insert triggers are defined on the table.

> My Guess:
> 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.
> Scott