Have you tried to edit a table design in 2008 and got this message?
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.
quick google search got me to this page
which shows the solution to go Tools menu -> Options -> Designers -> and uncheck "Prevent saving changes that require table re-creation"
The only thing to note here is that, if you have a slow system, these type of DDL changes may cause the GUI to not respond quickly.
No comments:
Post a Comment