Thursday, December 18, 2008 2:09 PM
I recently upgraded to 2008 to check out all the cool new stuff and I bumped into a wall within the first 5 minutes of testing. I off course created a dumb table that I'll like to populate with data so that I can play with the new features, however, after saving the original schema, I needed to add another column but I was unable to, instead I 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.
It seems Microsoft added a safety measure for DBA's who tend to make random alterations to tables which is usually ok unless its a pretty large table, it becomes scary!
Question: How do I get rid of that?
Answer: Simple! Go to Tools -> Options -> Designers and uncheck the box that states "Prevent saving changes the require table re-creation." and that's it. Viola!
