SQL Server Error - 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

Introduction

Here I will explain how to enable prevent saving changes in sql server or to solve the problem of “Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created.etc” in SQL Server.

Description

I have installed SQL Server 2008 in my laptop after successfully installed I opened SQL Server Management studio and created new table like this 

Once the table is created open the table in SQL Server Management studio and right click and select “Design” option Once the table is opened try to add or modify the existing columns in table and try to save then it will through error like 

“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”

After seen this error message I realized that “Prevent saving changes that require table re-creation” option was enable by default because of that we are getting this problem. 

Follow below steps to solve this problem 

          1) Open SQL Server Management Studio

          2) Go to Tools

          3) In that go to Options

          4) In leftside treeview select Designers

          5) In Designers select Table and Designers

        6) After that in right side “Uncheck” check box of Prevent saving changes that require table re-creation

After add above code run your application and check your output it will work for you

Demo

Now modify your table and save it now that table will save successfully into your database