In an effort to protect DBAs and developers from themselves, Microsoft has introduced a new default setting in SQL Server Management Studio. This setting prevents you from saving almost any change to db tables and throws out the following error:
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.
I don’t know about you, but I stopped reading at the second sentence because most Microsoft error messages do not contain super helpful information. In this case, however, they provide the solution, which is to uncheck “Prevent saving changes that require the table to be re-created.” This setting can be found in Tools -> Options -> Designers -> Table and Database Designers.
Don’t make this change if you work with db metadata.