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