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.
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.
Now try to save table changes .It will work.
Enjoy the weekend.
Thanks & Best Regards,