Disable Saving Changes is Not Permitted Dialog Box in SQL Server

Introduction

When we try to change an existing SQL server table, you might receive a Save (Not Permitted Dialog) box pop-up. This behavior is by default and happens under the following conditions: such as adding a new column to the middle of the table, dropping a column, changing column nullability, or changing the data type of a column.

When we click the cancel button, we receive another dialog as in the following.

Solution

To add a column to turn off the "Saving changes not permitted" dialog box so that you don't have to recreate a table to save changes to the table, follow these SQL Server 2008 configuration instructions:

On the Tools menu, click Options.

In the Options pop-up box, select designers. When we click on the option, the options window will be displayed:

 

Uncheck the option's check box that prevents saving changes that require the table to be re-created.

Summary

This article taught us how to Disable Saving Changes in the Not Permitted Dialog Box in SQL Server.