“Saving changes is not permitted.” SQL Server error when trying to save table changes

Dear All,
Sometime when we tried to save the changes in table of SQL Server we get the error like “Saving changes is not permitted.”  As shown in below figure.

Issue_While_Saving_Image

And when you tried to save the changes it will not save the changes.
To resolve this you need to follow below step
1)    Click on Tools menu
2)    Click on sub menu of tools which is “Options”
3)    Click on designer from open window
4)    Now uncheck “Prevent Saving changes that require table re-creation”.
5)    Now click on Ok button.

As shown in below fig.

Error_reason

Now try to save table changes .It will work.

Enjoy the weekend.

Thanks & Best Regards,
Rajat Jaiswal

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s