Options
ALTER sp before ALTER table
nvman_ca
Posts: 2
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?
Thanks,
Aaron
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?
Thanks,
Aaron
Comments
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
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378