Here I will explain how to solve problem in SQL Server 2008 Saving changes are not permitted.
I installed SQL Server 2008 and I created one new database after that I created one table and saved it everything working fine again I opened newly created table to change column name previously I entered wrong name again I changed column name and if I am trying to save that modifications I got error like this
After that I have changed some of options to rectify this error in SQL Server 2008
Follow these steps to solve this problem
1) 1) Open SQL Server Management Studio
2) 2) Go to Tools
3) 3) In that go to Options
4) 4) In leftside treeview select Designers
5) 5) In Designers select Table and Designers
6) 6) After that in right side “Uncheck” check box of Prevent saving changes that require table re-creation.
Now modify your table and save it now that table will save successfully into your database