Can’t Save Table Changes – SQL Server 2008

Posted on by

I added a new table to MSSQL via the SQL Server Management Studio tool. Then while still in design view I tried to make another change to the same table. When I hit the save button it says something like “saving changes not permitted because the table needs to be dropped and recreated”.

Looking in the options menu. I found a setting that was causing this problem. To disable this do the following:  Tools > Options > Designers > Tables and Designers > Uncheck the Prevent Saving Changes that require table re-creation option.

That fixes it for me.

  • http://chrisbarba.wordpress.com Chris

    This is a risk to turning off this option. You can lose changes if you have change tracking turned on (your tables).

    Chris

    http://chrisbarba.wordpress.com/2009/04/15/sql-se…

  • http://chrisbarba.wordpress.com Chris

    This is a risk to turning off this option. You can lose changes if you have change tracking turned on (your tables).

    Chris

    http://chrisbarba.wordpress.com/2009/04/15/sql-se…

  • José Carlos

    Thank You! I needed to disable this option.

  • José Carlos

    Thank You! I needed to disable this option.

  • http://www.greatwhitesoftware.com Jeffrey White

    Thank you for the tip! This was absolutely driving me nuts.

  • http://www.greatwhitesoftware.com Jeffrey White

    Thank you for the tip! This was absolutely driving me nuts.

  • http://www.dobox.com/ Bruce

    vale

  • http://www.dobox.com/ Bruce

    vale