Enabling SQL Server 2008 database to accept the changes made in a table

The SQL Server 2008 Management Studio will throw the following warning message when we tried to save the modification done in an existing table. It won’t allow us to save the changes in the table.

Warning Message:
“Saving changes is not permitted. The changes 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”.

We can fix this issue in Management Studio by un-checking a property. To fix this issue in Management Studio, Go To Tools > Options > Designer > Tables and Database Designs > uncheck the property “Prevent saving changes that require table re-creation”.