Thursday, December 16, 2010

SQL Server 2008 - Can't Save Changes to Table

When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the management tools will not allow you to save the changes.

error like the flowing window appear "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 be re-created"

image_thumb5


in management studio so go to tool>option and remove mark on Prevent Saving Changes that require table re-creation option

image


No comments:

Post a Comment