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:
- Open SQL Server Management Studio
- Click Tools menu options, then click Options
- From the left menu, choose Designers
- 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!
Comments