Saving Changes in 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

Once the table is created open the table in SQL-Server 2008 Management Studio by clicking on the table name and selecting “Design.” Try to add one more column to the existing table and click on save or CTRL+S. It will prevent it from saving and will show the above error in popup.

Solution

Go into the Tools -> Options and click on the Designers item in the tree menu on the left and make sure “Prevent saving changes that require table re-creation” is not ticked as below: