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.
You need to Disable “Prevent Saving Changes that requires the table re-creation”.
- Open SQL Server Management Studio (SSMS) 2008
- Click ‘Tools’ Menu
- Then Click ‘Options’ as shown
- In the navigation pane of the Options window, expand Designers node and select Table and Database Designers option as shown in the below snippet
Risks of Turing Off “Prevent Saving Changes that Require Table Re-creation” in SSMS
If you turn off this feature then you can avoid table recreation. However, if you have the Change Tracking feature of SQL Server 2008 enabled to track the table changes then the change tracking information will be lost completely whenever table is recreated. So, it is always advised to use this feature very carefully especially in a production environment.