If you’re new to SQL 2008, you’ve probably seen the following message:
The error 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.
You’ve probably done one of the following:
- Changed the data type of a column
- Dropped a column
- Added a new column to the middle of the table
- Changed the nullability of a column
- Altering the order of columns
There is a very simple fix to this…
Go to tools > options from the menu bar.
Select “Designers” from the Left Hand Side menu of the options dialog.
Uncheck “Prevent saving changes that require table re-creation”
Click OK