Home > Great Links > Saving changes is not permitted – SQL Server 2008 Management Studio

Saving changes is not permitted – SQL Server 2008 Management Studio

I ran into an error in SQL Server 2008 Management Studio when I tried to disable the Identity Specification on a column. It is a default setting problem, flipping the setting made it work. May be it makes more sense on a production system. But then Fool-Proofing everything will result in an unusable product. This is a perfect example.

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.

Read more in Rick Strahl’s blog here

Advertisements
Categories: Great Links
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: