Error message when you try to save a table in SQL Server: "Saving changes is not permitted"

blog.md

Error message when you try to save a table in SQL Server: "Saving changes is not permitted"‎‎​

I was trying to save a Diagram after some changes in the tables an got this error:

Saving changes is not permitted. The changes that 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.

To Prevent this error to happen, follow this steps:

1. Open SQL Server Management Studio (SSMS).
2. On the Tools menu, click Options.
3. In the navigation pane of the Options window, click Designers.
4. Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

References:

https://support.microsoft.com/en-us/help/956176/error-message-when-you-try-to-save-a-table-in-sql-server-saving-change

https://blog.sandro-pereira.com/2018/12/03/a-fish-out-of-water-saving-changes-is-not-permitted-the-changes-that-you-have-made-require-the-following-tables-to-be-dropped-and-re-created/

gistlog.yml

published: false