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
This entry was posted in Database Administration, T-SQL Tips & Tricks. Bookmark the permalink.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s