Aspdotnet-Suresh

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

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

Dec 1, 2011
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

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

Get the latest Asp.net, C#.net, 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

7 comments :

Anonymous said...

Can u post me Globalization/Localization concept with example please.

Anonymous said...

Ahh Thanks that was helpful indeed. I was in the same problem before.

duggu said...

Can u tell me about sharing sql server database over LAN..

Anonymous said...

Thanks..
But Prevent saving Changes Chek box is not present in sql server 2005

Vanitha P S said...

You not only given the theory but also
the Flow chart of practical view...i liked so much..
Thank you sir..

Unknown said...

hi ....


can you please help me in writing a query... please....reply sson...

Anonymous said...

sir..your all tutorials are very helpful for me ..thank you very much for your support.please be continue.

Give your Valuable Comments

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

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