How to Disable "Saving changes is not permitted" dialog box (SQL Server 2008)

by Updated March 17, 2011

When using SQL Server 2008, you may receive a Save (Not Permitted Dialog) box pop-up when trying to save changes to an existing table.  The dailog box reads:

"Saving changes is not permitted. The changes 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."

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:

  1. Open SQL Server Management Studio.
  2. On the menu choose Tools -> click Options
  3. In the Options pop-up box, expand Designers, and then click Table and Database Designers.
  4. Uncheck the option "Prevent saving changes that require the table to be re-created" check box.
  5. Click OK.

Now when you go to save changes to a Table, you will be permitted to do so.




anonymous by Muhammad Waqas on 12/27/2010
Thanks it works...
anonymous by Mihael Suzik on 3/17/2011
Thank you for detailed information and picture!

Add your comment

by Anonymous - Already have an account? Login now!
Your Name:  

Enter the text you see in the image below
What do you see?
Can't read the image? View a new one.
Your comment will appear after being approved.

Related Posts

I recently upgraded from Microsoft SQL Server 2005 to Microsoft SQL Server 2008 on my Windows Vista computer. After successfully installing SQL Server 2008, I could not find the Reporting Services instance installed. I have a feeling this was due to the...  more »

Here's one way to setup your connection string for a SQL Server 2008 Express database for a live website using ASP.NET on Windows Server 2008. Open "Sql Server Configuration Manager" -> the click on "SQL Server Network Configuration" -> then click...  more »