• Hi,

    Figure 6 is incorrect, you do not have to create the script and then return to the database model. You need to turn off the validation that SQL Management Studio has built in for changes that require a table to be recreated.

    The option is available at Tools | Options | Designers | Prevent saving changes that require table re-create.

    Regards,

    Mark P Ashworth

    http://www.connext.co.za