How to Disable "Saving changes is not permitted" dialog box (SQL Server 2008)
Updated March 17, 2011
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:
- Open SQL Server Management Studio.
- On the menu choose Tools -> click Options
- In the Options pop-up box, expand Designers, and then click Table and Database Designers.
- Uncheck the option "Prevent saving changes that require the table to be re-created" check box.
- Click OK.
Now when you go to save changes to a Table, you will be permitted to do so.