• Thank you all for the interest in my article, and for your comments.

     

    Generally I agree with Jean C. Bulinckx's comments regarding the triggers but in this particular article I described the process where the order of trigger creation should not affect the database upgrade.

     

    Regarding the solution suggested by Ian Yates: I used this approach when I was the only DBA and the only developer in the small start-up company; but when I moved to more complicated environment with many developers working at several sites, and had to support a number of clients running different version of our product, I realized that I need more comprehensive solution. However, when I install service packs or hot fixes in between the main releases, I use the similar solution but I wrap my SQL code into XML.

     

    And though the article might feel a bit long it is only because I tried to discuss as many common problems as possible, and provide ready solution for each situation.

     

    Thanks again,

     

    Serhiy Snisarenko