Saturday, October 22, 2011

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

When you try to make change in table design using SQL Server Management Studio, the above error comes. This is default setting of SQL Server SSMS that it doesn’t allow user to modify the schema of table and throws the message on saving. The setting is “Prevent saving changes that require table re-creation”. It can be changed through SSMS.
Start SQL Server Management Studio
Go to Tools menu than choose Option
Click Designers > Table and Database Designers
Now uncheck the option: “Prevent saving changes that required table re-creation.”
Click Ok.

No comments:

Post a Comment