Thursday, April 1, 2010

Prevent Saving Changes That Require Table Re-creation SQL Server 2008

I was modifying an existing table using SQL Server Management Studio 2008 R2, but I got this error message on saving:

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 occurs when the Prevent saving changes that require the table re-creation option is enabled. Also it occurs if you made one of these changes to the table:
  • Adding a new column
  • Change column Data type
  • Allow Nulls for a column
  • Change the order of a the table columns

To disable Prevent saving changes that require the table re-creation option follow these steps:
  • Open SQL Server Management Studio 2008
  • Go to Tools menu then Options
  • On Options Tree view, Click Designers
  • Unchecked Prevent saving changes that require the table re-creation option




Source: https://www.nilebits.com/blog/2020/03/prevent-saving-changes-that-require-table-re-creation-sql-server/