Saving changes is not permitted sql 2008 error

In this post we will discuss how to resolve the error Saving changes is not permitted in SQL 2008 error. This error usually comes when you try to modify in table structure and save it.

You can check some SQL server articles:

view in SQL server 2008

Difference between primary key and foreign key in SQL server 

Some Optimization Tips in SQL server

The full error message is “Saving changes is not permitted. The changes you ave 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 options Prevent saving changes that require the table to be re-created”.

Solution:
For this in the management studio click on Tools and then Options as shown in the figure below:

Then in the Options dialog box select Designers from the left side and after that uncheck the option: “Prevent saving changes that require table re-creation” and click on OK as shown in the figure below:


After that try saving, the error should not come.


You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →

Leave a Reply