Thursday, March 15, 2012

SSMS - Saving changes is not permitted

When you design a table in a SQL Server database and then try to make a change to a table structure that requires the table to be recreated, SSMS (SQL Server Management Studio) will not allow you to save the changes.

The error you will get is:
“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.”

Disable “Prevent saving changes that require the table re-creation” 
In SSMS go to Tools | Options | Designers | Tables and Designers as shown in the below snippet. Under Table Options you need to uncheck “Prevent saving changes that require the table re-creation” option and click OK to save changes. Now SSMS will work like expected.

Microsoft recommends that you do not work around this problem by turning off the Prevent saving changes that require table re-creation option. For more information about the risks of turning off this option, see the "More information" section in the kb article from Microsoft on :

No comments:

Post a Comment