How to Disable "Saving changes is not permitted" dialog box (SQL Server 2008)
Friday, April 24, 2009
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.