Trigger and Table script order

dennis@digitalfoundry.com · July 22, 2005 5:05PM

We added a column to an existing table, and modified the existing trigger on the table to reference the new column. When generating the sql diff script, it put the triggers first, then the alter table statement. The trigger script complains that the column does not exist. Is this a bug? I didnt see any options to control this behavior, we are using 3.0.0.130.

Brian Donahue · July 26, 2005 7:52AM

Hello Dennis,

Can you please upgrade to the latest version and see if the problem still occurs? For you, this will be a free upgrade that you can get from Help->Check for Updates or from our website.

dennis@digitalfoundry.com · July 26, 2005 1:13PM

Brian, I tried that and it said "The Update Service did not find updates for your application".

Brian Donahue · July 27, 2005 12:54PM

Hi Dennis,

We are currently on version 3.2.0.5. How about downloading the latest version from ftp.red-gate.com?

Trigger and Table script order

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk