ALTER sp before ALTER table

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

ALTER sp before ALTER table

Postby nvman_ca » Tue Sep 11, 2012 4:30 pm

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?

Posts: 1
Joined: Tue Sep 11, 2012 4:25 pm

Postby stanori » Thu Sep 13, 2012 10:36 pm

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.
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests