SQL 2008 Enable Changes To Tables
by Jon Hibbins on 8 October 2008
Filed under: Database, MSSQL2008, SQL Server, TSQL
If you get the error in the SQL 2008 Management Studio :
“Saving changes 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 can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.”
You can enable changes inside the Microsoft SQL Server Management Studio by going to ‘Tools|Options|Designers’ then unchecking the ‘Prevent saving changes that require table re-creation’ option
November 6th, 2008 at 4:58 pm
Hey Thanks for the tip! It worked just fine! =)
November 24th, 2008 at 5:23 am
Thanks for the suggestion!!!
February 1st, 2009 at 4:37 pm
Heeeeeey, Thanks …. :>
you made me really happy, I searched at least for 5 hours for your solution, and didnt find any working solution ! ….
again, thanks …
February 14th, 2009 at 8:13 am
Fuuhhh!! thank you, thank you.
March 5th, 2009 at 10:03 pm
Thanks for this tip. A quick google search to the best answer! I wasn’t looking forward to dropping all my tables.
April 16th, 2009 at 12:42 pm
Thanks mate, first site Mr.Google found, very quick solution
April 28th, 2009 at 7:30 am
Thanks!!!
June 15th, 2009 at 10:16 am
Thanks!
June 16th, 2009 at 3:34 pm
Thanks, quick and to the point
June 16th, 2009 at 3:34 pm
Thanks, quick and to the point
February 18th, 2010 at 1:13 am
Quick tip, thanks
June 25th, 2010 at 1:25 pm
Thanx buddy… Its working
July 20th, 2010 at 9:07 pm
God bless microsoft. Introduce a new option that no-one wants and then not bother to tell you how to disable it.
April 19th, 2011 at 8:01 am
Just wanted to thank you for your post
May 31st, 2011 at 6:53 am
thank you very much for this post it very useful for me