LLBBL

5 words

Can’t Save Table Changes – SQL Server 2008

November2

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.

posted under News

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

3 Comments to

“Can’t Save Table Changes – SQL Server 2008”

  1. On December 30th, 2009 at 3:01 pm Chris Says:

    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...

  2. On January 21st, 2010 at 9:45 am José Carlos Says:

    Thank You! I needed to disable this option.

  3. On February 18th, 2010 at 11:15 pm Jeffrey White Says:

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

Email will not be published

Website example

Your Comment: