SQL 2008 Management Studio – Saving changes is not permitted

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.

Author: James

IT Manager - Network, Web coding, MS SQL and Online Mapping expert

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: