;

SQL Server Error: Saving Changes is not permitted


Tutorialsrack 10/10/2021 SQL Server

In this article, you’ll learn how to fix the SQL Server error: save changes is not permitted. This problem occurs when you try to save a table after making changes to the table using Designer in SQL Server Management Studio, you may receive the following error message:

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.

By default, Prevent saving changes that require the table re-creation  option is enabled in SQL Server Management Studio which causes this problem.

But the good news is that It is a very easy and simple setting problem that can be fixed in 5 seconds by following these steps:

To allow you to save changes after you alter the table, please follow these steps to change your SQL Server setting:

  1. Open SQL Server Management Studio
  2. Click Tools menu options, then click Options
  3. From the left menu, choose Designers
  4. Uncheck the box entitled Prevent saving changes that require table re-creation

Press OK to save

That's it.

I hope this article will help you to understand how to fix the SQL Server error: save changes is not permitted.

Share your valuable feedback, please post your comment at the bottom of this article. Thank you!


Related Posts



Comments

Recent Posts
Tags