Error:
Saving changes is not permitted. The changes that 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.
Resolution:
1. Open SQL Management Studio as an administrator
2. Go to Tools, then Options then "Designer"
3. Uncheck the Prevent saving changes that require table re-creation
4. Expand the database tables on the left object explorer of SQL Server
and make the changes you plan to make.
5. You may want to re-check the Prevent saving changes that require table re-creation
in order to for the security feature to warn again.
