How to bypass the “Saving changes is not permitted…” message in Microsoft SQL Management Studio

You made a change to a Microsoft SQL Server database table that requires the re-creation of the table you get the following error message when you try to save your changes:

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.

Cause:

Microsoft SQL Server Management Studio doesn’t allow the re-creation of the table if the following option is set in the Microsoft SQL Management Studio configuration:

SQLServer_PreventSavingChangesTableRecreation

Solution:

  • In the Tools menu select “Options…”,
  • On the left pane select “Designers”,
  • Uncheck the “Prevent saving changes that require table re-creation” check box.

Leave a Reply