Getting the following error in SQL server 2008 while making changes to a table structure that requires the table to be recreated
"Saving changes is not permitted.Changes you have made require tables to dropped and re-created."
To fix this,
Go to Tools -> Options -> Designers -> Tables and Designers and uncheck the Prevent Saving Changes that require table re-creation option.
====