Monday, January 11, 2010

SQL Server 2008 - Saving Changes is Not Permitted?

Extracted from CodeSlammer:
"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."

This is now the default behavior for any of the following changes to a table:

  • Adding a new column to the middle of the table
  • Dropping a column
  • Changing column nullability
  • Changing the order of the columns
  • Changing the data type of a column
In order to prevent this default behavior, uncheck the following:





No comments: