Upgraded my management desktop recently and made sure I had the latest SQL 2008 Management studio, even though i’m still managing only SQL 2005 databases – works perfectly with older versions.
I edited a table and inserted some columns on trying to save the table I got the following message:
“Saving changes is not permitted. The changes that 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.”
After much searching I came across the following Microsoft article:
Problem solved. The old SQL 2005 management studio did not have this function, it was only added in 2008 and the default was set to on – to accomodate change tracking it seems! Another example of Microsoft catering to enterprise customers and not their core small business market.