Saving Change is not Permitted Error while Saving Changes in a table in SQL

Saving Change is not Permitted Error while Saving Changes in a table in SQL

One of the developer in our company was trying to save the changes in a table he was changing the name of a column through Graphic Interface 

Right click table -Design -Changing column name 

But when he tried to save the changes he got the error Saving Change is not Permitted.

He again tried  the same but failed again with same error as in below screenshot..

So,Below is the solution

In order to Save the changes you just have to do the below steps

Go to Menu bar of SSMS-Tools-Options-Designers

-Prevent saving Changes that require table re-creation -Uncheck this box

-ok

Now try to save changes in table it will save Succesfully.