What are the challenges you face when working across database platforms? Take the survey

trigger fire order

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited April 29, 2004 1:03PM in SQL Compare Previous Versions
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.


Brian Donahue
Red Gate Technical Support

"Phill Darmanin" <philld@software360.com> wrote in message
> Is there are reason why triggers aren't recreated in the order in which
> were originally created? I know we should probably name them
> but try telling our developers that.
This discussion has been closed.