Error message when you try to save a table in SQL Express Server

"Saving changes is not permitted" in SQL Express Server

This problems appear when the Prevent saving changes that require the table re-creation option is checked or enabled. And usually you make the any one changes from following option to table.

• Want to change Allow NULL property of a column
• Want to Reorder the columns
• Want to modify the column data type
• Want to add new column in the table

When you do any one from the above option then you see the following screen or error:

Prevent saving changes that require the table re-creation

Solution:

very Simple and easy solution about this problem.

1.  Open a project in Visual Studio.
2. Click on Tools menu from top and go to Options...
3. Option window will appear. On this window select the Database Tools -> Table and database designers -> Table and Diagram options from the left panel.
4. uncheck the Prevent saving changes that require the table re-creation.
5. At the end click on Ok button.

Solution Screens: