SQL Tips – Saving Changes Not Permitted

If you’re new to SQL 2008, you’ve probably seen the following message:

sql2008_nosave

The error reads:
Saving changes is not permitted. The changes 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.

You’ve probably done one of the following:

  • Changed the data type of a column
  • Dropped a column
  • Added a new column to the middle of the table
  • Changed the nullability of a column
  • Altering the order of columns

There is a very simple fix to this…
sql2008_nosave2

Go to tools > options from the menu bar.
Select “Designers” from the Left Hand Side menu of the options dialog.
Uncheck “Prevent saving changes that require table re-creation”
Click OK

Posted in SQL Tips, Tips

Leave a Reply

Your email address will not be published. Required fields are marked *

*