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 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
Introduction

Here I will explain how to solve problem in SQL Server 2008 Saving changes are not permitted.

Description

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

2 comments :

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...

THANKS dude

Give your Valuable Comments

Other Related Posts

© 2010-2012 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.