Saving change is not permitted MS SQL 2008
May 4, 2009 at 5:38 am Australian Search Engine 7 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.
Australian Search Engine
websitedesignaustralia
Taco Fleur
kyliewrites
cazazz
Jim Petrakis
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..
cheers!
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