SQL Server 2008 Management Studio: Saving changes is not permitted.
In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead:
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.
This is by design, but can be changed in the Management Studio Options:
go to Tools , Options then go to the Designer Page and uncheck “Prevent saving changes that require table re-creation”.
go to Tools , Options then go to the Designer Page and uncheck “Prevent saving changes that require table re-creation”.
