Saving changes is not permitted

In SQL SERVER 2008 probably face with such this error:

Saving changes is not permitted. The changes you have made require the following table 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.

For avoide prompting above dialog box clear the check box in bellow path:

Tools Menu >> Options >>Designers >>Prevent saving changes that require the table to be re-created

We must know that following actions might require a table to be re-created:

  1. Adding a new column to the middle of the table
  2. Dropping a column
  3. Changing column nullability
  4. Changing the order of the columns
  5. Changing the data type of a column
Advertisements