'Saving changes is not permitted' error when you try to save a table in SQL Server
This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Functional differences in Atlassian Cloud, the contents of this article cannot be applied to Atlassian Cloud applications.
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.
- Open SQL Management Studio as an administrator
- Go to Tools, then options then "Designer"
- Uncheck the Prevent saving changes that require table re-creation
- Expand the database tables on the left object explorer of SQL Server and make the changes you plan to make
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