Sql Server Management Studio 2005/2008 : 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.

Error

Saving changes is not permitted

While working with SQL Server Management Studio, sometimes you get this error. Saving Changes is not permitted. Most probably you are running your SQL Server Management Studio into the New/Formatted Computer. Because you are pretty sure that you have done a similar operations a thousand times and it all ran fine without any error. Well, this error is happening when you are trying to modify the structure of the Table. This change requires SQL Server to drop and recreate the Table.

There is an option available in SQL Server Management Studio "Prevent saving changes that require table re-creation". You actually have to disable this options. Following screen shots describes step by step process of disabling this option.

Go to Tools => Options

SSMS Options

Select Designer => UnCheck Prevent saving changes that require table re-creation

Uncehck The Designer Option

Click OK to exit out from this window. Once you are done with this, go ahead try doing the operation you tried before and got this error message. You should not see any errors this time and all the structural changes you have made to the Table will be saved without any problems.