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