Save not permitted in SQL Server 2008 - Management Studio
For those new to SQL Server 2008
, you have probably got this message the first time you tried to change a table design.
"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 a table to be re-created"
When trying to change the columns in some tables, add columns or change null settings, you'll get the "Saving changes is not permitted" error and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file, not very useful.
The solution is pretty easy: Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".