Reader Level:
Articles

Disable Saving Changes is Not Permitted Dialog Box in SQL Server

By Rohatash Kumar on 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
  • 4851

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

Rohatash Kumar

Normal 0 false false false EN-AU X-NONE X-NONE I am a Microsoft .NET software Developer and author and C# Corner MVP. I hold Masters degree i... Read more

COMMENT USING

Trending up