Save (Not Permitted)

SQL 17 August 2011 | 0 Comments

Prevent saving changes that require table re-creation

When using the SQL designer to modify table structures (changing column order, changing datatypes) that requires the table to be recreated, the management tools will not allow you to save the changes. You will get an error stating, “You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require […]

Tagged in , , , ,