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”


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!


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



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

    thanku somuch


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

    works great!… thx


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


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

    Thanks a lot… 🙂


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

    thank a lot


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

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


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

    Thanks 🙂


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

    Thanks a lot



Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


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 20 other followers


Top Rated

Top Clicks

  • None

Blog Stats

  • 170,674 hits

%d bloggers like this: