Friday, March 5, 2010

Saving changes not permitted

Last week I had following error when I tried to save some changes in the SQL Server Management Studio 2008.

“Saving changes is not permitted. The changes that 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.”

This error happens because by default the  Prevent Saving Changes That Require Table Re-creation option is enabled by default in SQL Server 2008 Management Studio.

To disable this option:

  • Open SQL Server 2008 Management Studio
  • Click Tools and then Options
  • Expand the Designers node and select Table and Database Designers option
  • Uncheck “Prevent saving changes that require the table re-creation”
  • Click OK to save changes

No comments: