SQL Server Error: Saving Changes is not permitted | Quisitive
SQL Server Error: Saving Changes is not permitted
June 25, 2013
Quisitive
How to fix SQL server error not saving changes.

When you install the Microsoft SQL Server Management Studio, the default settings do not allow you to save any changes to the structure of your tables that would cause the tables to be dropped and recreated and creating an error commonly known as SQL server error, which can be extremely limiting when you are needing to make a quick change using the interface.

SQL Server Error Solution

The good news is that it is very easy to change this setting by following these steps:

  1. Open SQL Server Management Studio
  2. From the file menu, choose Tools à Options
  3. From the left menu, choose Designers
  4. Uncheck the box entitled Prevent saving changes that require table re-creation
  5. Press OK to save

That’s it!

More SQL content:

  1. Float vs Decimal in SQL
  2. Cannot resolve the collation conflict

SQL Server 2012 and 2012 R2 End of Life

As you may know, Microsoft SQL Server 2012 reached its end of life on July 12, 2022, and Windows Server 2012 reached its end of life on October 10, 2023.

Simplify your migration from Windows and SQL Servers to Microsoft Azure with Quisitive. Quisitive will assess your current environment, plan your migration, build your Azure infrastructure, migrate your workloads, and optimize your environment.

Learn more about our Windows & SQL Server to Azure Migration program.