Reader Level:
ARTICLE

Disable Saving Changes is Not Permitted Dialog Box in SQL Server

Posted by Rohatash Kumar Articles | SQL May 14, 2012
When we try to change an existing table in SQL Server 2008, you might receive a Save (Not Permitted Dialog) box pop-up. This article explains the error and what to do about it.
  • 0
  • 0
  • 4270

When we try to change an existing table in SQL Server 2008, 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.

img1.jpg

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

img2.jpg

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 in order to save changes to the table, follow these SQL Server 2008 configuration instructions:

On the Tools menu, click Options.

img3.jpg

When we click on the option, the option window will be displayed:

img4.jpg

In the Options pop-up box select designers.

img9.jpg

Uncheck the check box of the option that prevents saving changes that require the table to be re-created:

img7.jpg

COMMENT USING

Trending up