How To Fix ‘Saving changes is not permitted’ Error In SQL Server

In this article, we will learn how to fix Saving changes is not permitted error in SQL Server.

When I try to edit the table design in SQL Server (Like add column or change data type of column, etc.), I got this error.

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.

The Save dialog box warns that saving changes is not permitted because the changes I have made require the listed tables to be dropped and re-created. But if I just want to change column’s data type, so why do I have to re-create the table?

Let’s follow the steps given below to fix this issue and allow SQL Server to edit the table design:

First click on the Tools menu and then click Options… to open the Options popup.

Now expand the Designers option and then click the Table and Database Designers.

Now uncheck the Prevent saving changes that require table re-creation check box.

Now just click the OK button and then restart your SSMS (SQL Server Management Studio).

 

As we can see fixing Saving changes is not permitted error in SQL Server is very easy. Please give your valuable feedback and if you have any questions or issues about this article, please let me know.

Also, check How To Connect SSMS To Local Default Instance

Submit a Comment

Your email address will not be published. Required fields are marked *

Footer Logo

Subscribe

Select Categories