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:

InRiver: Not loading your extensions?

(You really need to in the loop to appreciate the issue this post addresses). Man, I've been fighting this problem for hours before I ...