Saving change is not permitted MS SQL 2008

May 4, 2009 at 5:38 am Taco Fleur 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: ms sql 2008.

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!

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

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

thanku somuch

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

works great!… thx

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

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

Thanks a lot… 🙂

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

thank a lot

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

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

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

Thanks 🙂

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

Thanks a lot

LikeLike
Reply