'Saving changes is not permitted' error when you try to save a table in SQL Server

 

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.