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

1 comment:

Sophie Grace said...

Nice post. I was checking constantly this blog and I’m impressed! Extremely useful info specially the last part I care for such information a lot. I was seeking this certain info for a long time. Thank you and good luck. 192.168.254.254

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...