Sibeesh Passion

Solution for saving changes not permitted error in SQL




  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Introduction

Hi All, How are you today? In this article we will see a solution for a fix that we usually encounter when you work in Microsoft SQL server. The error message will be “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 we can solve this issue. I hope you will like it.

Background

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

www.sibeeshpassion.com

Steps to follow

To fix this issue, you need to follow some certain steps. We will explain that here.

Step 1

Go to Tools menu and click on options.

www.sibeeshpassion.com

Step 2

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

www.sibeeshpassion.com

Step 3

Now go to Designers menu and click on “Table and Database designers”

www.sibeeshpassion.com

Step 4

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

www.sibeeshpassion.com

That is all. Now if you try to save that table, you won’t be facing above mentioned issue. Have a happy table designing.

Conclusion

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

Thanks in advance. Happy coding!

Kindest Regards
Sibeesh Venu

Footer With Address And Phones