“Saving changes is not permitted…” in SQL Server 2008 Management Studio
Aug 15 2010 · Databases
The issue occurs when saving changes that would require dropping and recreating a table (e.g. messing around with columns). I would think a warning would be sufficient instead of a restriction that requires digging through the app options window (which is not even hinted at in the popup). I also can’t imagine how effective this would be; unless you design your schema perfectly the first time around you’d always encounter this issue and need to disable this “feature” as you made changes.
The fix is to go to Tools » Options » Designers and uncheck “Prevent saving changes that require table re-creation”
h/t to Deems’ Weblog for the solution.