When working with SQL Server Management studio, if you use the Design view of a table and attempt to change a table then it shows this message “Enable saving of changes that require table to be re-created SQL server 2008″.
“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.”
it is enabled by default when you install SQL Management Studio.
This is a great feature to prevent accidents from occurring
For the developer or programmer its a noising matter, to prevent this message go to Tools > Options > Designers > Table and Database Designers > Prevent saving changes that require table re-creation. Turn this option off.
see the image:
Now you will be able to save the tables again.
Warning: As the above article states, it is not recommended that you turn off this option (at least not permanently), as it will ensure that you do not accidentally change the schema of a table such that data is lost. Do so at your peril.