SQL 2008 Management Studio – Saving changes is not permitted

Advertisements

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:

http://support.microsoft.com/kb/956176/en-gb

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s