Saving changes is not permitted in Sql Server 2008

Saving changes is not permitted in Sql Server 2008

Saving changes not permitted. The Changes you have made require the following tables to be dropeed. On Save of table object Error Save (Not Permitted) Dialog Box in Sql Server 2008

When we are using sqlserver 2008 earlier days of our experience you will get this issue often on doing bellow changes for a table

• Adding a new column to the middle of the table
• Dropping a column
• Changing column nullability
• Changing the order of the columns
• Changing the data type of a column

The error like bellow
 

1. Error we get when try to do any operations on table

We can resolve this irritate message, where in this option is not selected by us. this default selection of management studio

To resolve this issue go to Sqlserver Management Studio>Tools>Options>Expand Designers>Click on Table and Database designers> Uncheck "Prevent Saving changes that requires table re-creation" like bellow

2.By following this above we can resolve this issue

    after doing successfully now try to change table. it will resolve.