GotKnowHow.com

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

by


Uncheck the checkbox next to "Prevent saving changes that require table recreation"

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.

 


0
2

2 Comments

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:  

Comment:  
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.

Ask a Question

140 characters left

Recent Articles

Follow Us...