In SQL Server 2008 Management Studio, saving changes to the design of a table that requires the table to be dropped and recreated is not possible, but will show the following message instead:
Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.
You have either [...]
Click here to see the original post