Saving change is not permitted MS SQL 2008

May 4, 2009 at 5:38 am 10 comments


Been battling with MS SQL 2008 and ran across the issue (it’s actually a feature!) of not being able to save changes made to a table in designer view. I got the following error:

Saving change is 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 cant be re-created or enabled the option Prevent Saving changes that require the table to be re-created.

Seems there is an easy fix (if you know where to look), go to
Tools Menu >
Options >
Designers >
And untick the option “Prevent saving changes that require a table re-creation”

Advertisements

Entry filed under: MS SQL. Tags: .

Convert HTML entities from XML in JavaScript ColdFusion Flickr Photos API

10 Comments Add your own

  • 1. Michael  |  July 5, 2009 at 8:16 pm

    Wow, thanx!

    Like

    Reply
  • 2. Werner  |  December 3, 2009 at 2:44 pm

    Thanks so much!

    And a biig biig biiig ShameOnYou to MicroSoft. Never seen such bull**** produced by a company with such a vast amount of developers (well actually their managers and designers are at fault) and such a vast amount of money..

    cheers!

    Like

    Reply
  • 3. swapy  |  January 5, 2010 at 5:54 am

    thanku somuch

    Like

    Reply
  • 4. raaiman  |  July 1, 2010 at 1:19 pm

    works great!… thx

    Like

    Reply
  • 5. Bob  |  July 5, 2010 at 11:50 am

    Thanks so much. I had been importing data and needed to make changes to the tables after the import but was locked out. I tried several techniques to get the modifications to save. Googled the problem – clicked your solution – it worked. Should have googeled it first. Would have saved hours of frustration.

    Werner: I’m actually fine with the initial lock out of changes. Protects structure and data — especially when moving large amounts of important data. Where I think MS dropped the ball is in the info box that pops up it doesn’t point us to this solution!

    Like

    Reply
  • 6. Wing_Shards  |  February 3, 2011 at 7:07 am

    Thanks a lot… 🙂

    Like

    Reply
  • 7. tung  |  February 14, 2012 at 2:33 am

    thank a lot

    Like

    Reply
  • 8. THOMAS  |  April 17, 2012 at 10:32 am

    WOOOO..thank u …it worked in seconds!!!:D

    Like

    Reply
  • 9. pasupathig  |  May 9, 2012 at 6:23 am

    Thanks 🙂

    Like

    Reply
  • 10. Muktadir  |  June 21, 2012 at 3:58 am

    Thanks a lot

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 19 other followers

Archives

Top Rated

Blog Stats

  • 167,579 hits

%d bloggers like this: