Saving Changes is not Permitted

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.

There is nothing to say,  this website below does a great job at explaining how to fix this issue.
http://www.sql-server-performance.com/faq/saving_changes_not_permitted_p1.aspx

The most common operation I usually do is to change a Column Size in Real time.

ALTER TABLE NAMEOFTABLE  ALTER COLUMN ycsoftware varchar(1000);

For more information about altering table with Command Lines visit the following Microsoft Article:
http://msdn.microsoft.com/en-us/library/ms190273.aspx

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn