infolink

Tuesday, 21 April 2015

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
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:



No comments:

Post a Comment