Saving changes is not permitted in SQL Server

Question

I have created a table in SQL Server and edited the design of the table. When I try to save changes it shows a "Saving changes is not permitted” warning window as below and I can't save the new changes to my table. 

How to solve this issue to save changes in SQL Server?

Answer 1

Saving changes is not permitted in SQL Server

In SQL Server Management Studio when altering column’s datatype in the table design and save the changes it drops the table and re-creates a new one, by default this action is prevented.

Follow these steps to change this option:

1. Go to Tools in menu -> Options -> Designers.
2. Uncheck Prevent saving changes that require the table to be re-created -> Select Ok