«
»


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

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

15 Responses to “SQL 2008 Enable Changes To Tables”

  1. Oscar Says:
    November 6th, 2008 at 4:58 pm

    Hey Thanks for the tip! It worked just fine! =)

  2. Arun Says:
    November 24th, 2008 at 5:23 am

    Thanks for the suggestion!!!

  3. Mehran Says:
    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 …

  4. helmi Says:
    February 14th, 2009 at 8:13 am

    Fuuhhh!! thank you, thank you.

  5. Paul Kukiel Says:
    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.

  6. Josef Says:
    April 16th, 2009 at 12:42 pm

    Thanks mate, first site Mr.Google found, very quick solution :)

  7. Chuck Conway Says:
    April 28th, 2009 at 7:30 am

    Thanks!!!

  8. Gareth Says:
    June 15th, 2009 at 10:16 am

    Thanks!

  9. Jason Says:
    June 16th, 2009 at 3:34 pm

    Thanks, quick and to the point :-)

  10. Prop2Go Says:
    June 16th, 2009 at 3:34 pm

    Thanks, quick and to the point :-)

  11. Suresh Says:
    February 18th, 2010 at 1:13 am

    Quick tip, thanks

  12. Mayank Says:
    June 25th, 2010 at 1:25 pm

    Thanx buddy… Its working

  13. james Says:
    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.

  14. Anis Says:
    April 19th, 2011 at 8:01 am

    Just wanted to thank you for your post

  15. nattapon Says:
    May 31st, 2011 at 6:53 am

    thank you very much for this post it very useful for me

Leave a Reply