Saving changes is not permitted. The changes you made require following tables to be dropped and re-created – SQL SERVER 2008

ay while working in SQL Server 2008, I encounter an interesting problem which does not allow me to change design of any table in particular database. Each time when I try to change table columns or resize the I receive following message,

Saving changes is not permitted. The changes you made require following tables to be dropped and re-created. You have either made changes to a table that can’t be recreated or enabled the option prevent saving changes that require the table to be re-created. 

Fig – (1) SQL Server 2008 – Saving changes is not permitted

         You will receive this message when you restore database created on other server. SQL Server 2008 by default prevent changes for database which are created on another server by enabling “Prevent saving changes that require table re-creation” from Tools – Options.

Fig – (2) Solution – SQL Server 2008 – Saving changes is not permitted

    To solve this go to Tools – Options and uncheck “Prevent saving changes that require table re-creation” option.