Saving change is not permitted MS SQL 2008
May 4, 2009
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.
2 Comments Add your own
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed
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!