Saving changes is not permitted -- SQL 2008

When I try to modify a table, for example, change the "allow null" property of a column, or add a new column to the table, I encounter the message like this:


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.


It is said that you may change the metadata structure of the table and cause data loss in 'change tracking information'. However, it is so annoying that at the beginning of developmental stage, when the structure of table is subject to change, that we need to re-create the tables.

Here is the way to turn off the feature:
in SQL2008, Tools->Options->Designers->Table and Database Designers
uncheck "Prevent saving changes that require table re-creation".

Microsoft support: see this