In Sql Server 2008, you may be unable to modify tables if they require a table rebuild. The error you get is as follows:
Saving changes is not permitted. The changes you have made require the following table 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 recreated.
In order to get around this error you have to click Tools–>Options–>Designers and uncheck the check box for Prevent saving changes that require table re-creation.
hello
thanks a lot