aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

SQL Server 2008 ERROR: Saving changes are not permitted. The Changes you have made require the following tables to be dropped and re-created.

Dec 28, 2010

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
Happy coding……

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Zia said...

thanks for this tip dude. I used to script the table to new query window, make changes and create it again.

Anonymous said...


Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.