trigger fire order
Brian Donahue
Posts: 6,590 Bronze 1
Hi Phil,
I'd assume that it probably has something to do with dependency order.
If a trigger updates TableA, for example, TableA should be modified before
the trigger is created. This prevents errors from happening when the scripts
are run.
Regards,
Brian Donahue
Red Gate Technical Support
"Phill Darmanin" <philld@software360.com> wrote in message
news:SrfsWNgLEHA.1428@server53...
> Is there are reason why triggers aren't recreated in the order in which
they
> were originally created? I know we should probably name them
alphabetically
> but try telling our developers that.
>
>
I'd assume that it probably has something to do with dependency order.
If a trigger updates TableA, for example, TableA should be modified before
the trigger is created. This prevents errors from happening when the scripts
are run.
Regards,
Brian Donahue
Red Gate Technical Support
"Phill Darmanin" <philld@software360.com> wrote in message
news:SrfsWNgLEHA.1428@server53...
> Is there are reason why triggers aren't recreated in the order in which
they
> were originally created? I know we should probably name them
alphabetically
> but try telling our developers that.
>
>
This discussion has been closed.
