“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.”

Management Studio 2008 has a default that prevents saving table changes from the designer when the table will need to be rebuilt. I’m constantly being asked about this error by developers:

“Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.”

To be able to make table changes go to Tools->Options->Designers and uncheck “Prevent saving changes that require table re-creation”.

It’s a good idea to do this as soon as you install 2008. Tell everyone around you. I’m asked about it quite often.

Advertisements

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: