After installing Sql Server 2008 one of my developers was having a hard time trying to save updates to any of our database tables. Every time he tried to save a table alteration he was presented with the error.
Saving changes is not permitted. The changes 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.
The error is helpful enough in telling us clearly what the problem is, and how to fix it – (or enabled the option Prevent saving changes that require the table to be re-created). However, in true Microsoft form we need to hunt down the option ourself.
To make life easier here is where the option resides.
Tools > Options > Designers
Once there you will see the following checkbox option
Prevent saving changes that require table re-creation
Uncheck this and click OK. Simples!