ALTER sp before ALTER table

nvman_canvman_ca Posts: 2
edited September 13, 2012 5:36PM in SQL Compare Previous Versions
I did a sql compare and the generated script has an ALTER sp before the ALTER table where I had added a new column.

So I have to manually modify the script to put the ALTER table before the ALTER sp.

Did I miss something during the script generation?



  • Hi nvman_ca,

    What build of SQL Compare are you running? You could try the following under the "options" tab in the project setup:

    - Add object existence checks
    - Force Column order

    Best Regards,
    Steve Tanori
    Product Support
    Red Gate Software Ltd.
Sign In or Register to comment.