02 June, 2010

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.

SQL server is sometimes source of irritation! If you are not careful – you might run into this obstacle I just had today. Trying to edit a table definition directly in SQL Server Management Studio, I got the error message:

“Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.”

In itself – it is an okay error as we do not want to delete data (sometimes!). But where do you change this behavior when you actually do want to change a table definition and don’t care about the data inside the table. Well – uncheck this setting and you are good to go!

prevent

No comments:

iPhone/XCode - not all cases are equal!

This bit me! Having made some changes to an iPhone application (Obj-C); everything worked fine in the simulator. But, when deploying the s...