'Saving changes is not permitted' error when you try to save a table in SQL Server

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.


Some Confluence troubleshooting steps require you to make changes to a SQL Server database. Depending on your SQL Server configuration, you may get the following error when making structure/schema changes: 

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.



This warning that prevents the actions from completing is caused by the Prevent saving changes that require table re-creation option being triggered in SQL Server. This option lets SQL Server to prevent structure changes when a table needs to be recreated and is intended as a security feature. However, this also prevents planned changes from completing. 


The resolution is to uncheck the Prevent saving changes that require table re-creation option:

As with all recommendations made by Atlassian Support, please follow best practices for Change Management and test and validate these settings in a Test/Development and Staging environment prior to rolling any changes into a Production environment. This is to validate these changes and ensure that they will function will within your infrastructure prior to placing these changes in production.

  1. Open SQL Management Studio as an administrator
  2. Go to Tools, then options then "Designer"
  3. Uncheck the Prevent saving changes that require table re-creation
  4. Expand the database tables on the left object explorer of SQL Server and make the changes you plan to make
  5. You may want to re-check the Prevent saving changes that require table re-creation in order to for the security feature to warn again


Last modified on Mar 30, 2016

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.