SQL Server - Saving changes is not permitted error message in SQL Server Management Studio
When you try to save a table after making changes to the table using Designer in SQL Server management Studio, you may receive the following error message:
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.
This problem occurs when you make one or more of the following changes to the table:
You change the Allow Nulls setting for a column.
You reorder columns in the table.
You change the column data type.
You add a new column.
You change the filegroup of a table or its text/image data.
Cause
This problem occurs because the Prevent saving changes that require the table re-creation option is enabled by default in SQL Server Management Studio.
When you change a table so that you alter the metadata structure of the table, and then you save the table, the table must be re-created based on these changes. This may result in the loss of metadata and in a direct loss of data during the re-creation of the table. If you enable the Prevent saving changes that require the table re-creation option in the Designer section of the SQL Server Management Studio (SSMS) Options window, you receive the error message that is mentioned in the 'Symptoms' section.
