Solution For Saving Changes Not Permitted Error in SQL

Introduction

In this article we will see a solution for an error message that we usually encounter when working on Microsoft SQL Server. The following is the error message: 

“Saving changes is not permitted, the changes you have made require the following table to be dropped and re-created. You have either made changes to the table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created”.

 

Let us see how to solve this issue. Please see this article on my blog here. 

Background

As the error message says, it is because you have enabled the option Prevent saving changes. Now we will see how to disable that option in SQL Server Management Studio. Before going through the fix, we will see the screenshot of the error.

 

Procedure to follow

To fix this issue, you need to use a certain procedure. We will explain that here.

Step 1

Go to the Tools menu and click on Options.

 

Step 2

Now you can see a window is opened as follows. You can see some settings there. There is no need to change anything in that. 

Step 3

Now go to the Designers menu and click on “Table and Database designers”.
 
Step 4

It is time to change the settings. As you can see there is a check box captioned as “Prevent saving changes that requires table re-creation” . Just uncheck that and click OK.
 

That is all. Now if you try to save that table, you won't be facing the preceding issue. Have a happy table designing.

Conclusion

I hope you will like this article. Please share with me your valuable thoughts and comments. Your feedback is always welcomed.

Thanks in advance. Happy coding!