Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
0 like 0 dislike
in SQL Server by 11 20 27

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?

1 Answer

1 like 0 dislike
by 11 20 27

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
If you don’t ask, the answer is always NO!