management tools

Solved: Saving changes is not permitted. The changes you have made...

Submitted by admin on

If you are working with SQL Server Management Studio Tools and encounter the following error when modifying one of your tables:

“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.”

All you have to do is unchecked the “Prevent saving changes that require the table to be re-created” under the tools menu.

Follow the screenshot below to disable it.