How to resolve 'Saving changes is not permitted' error message in SQL Server 2008 R2?

You came across with this error in SQL Server Management Studio  everytime when you made some modifications in a table, i.e. adding relationships.

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

Workaround:

This is by design and can be quickly fixed in Management Studio by unchecking a property. To fix this in Management Studio, go to Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation".

URL: http://mssql-tech.blogspot.com/2011/11/how-to-resolve-saving-changes-is-not.html

Other References:

http://weblogs.asp.net/pabloperalta/archive/2008/09/23/sql-2008-quot-saving-changes-is-not-permitted-quot-error-message.aspx