I receive the following error message when trying to save changes in the SSMS 2008 table designer:
"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.
DBType" (= name of table that cannot be saved)
I am logged on as a sysadmin when this happens. The computer has nothing on it but Vista RTM and SQL 2008 November CTP using domain accounts for all services (except SQL Browser which uses NT Authority). This is a default instance with default settings used for setup and all components installed. I have not experienced this behavior in any SQL 2000 or SQL 2005 installation with any service pack up through SQL 2005 SP2.
This error does not occur if the same modification is made via an ALTER TABLE statement in a query window.