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

In SQL Server 2008, while you try adding a new column, even though ‘is null is true’, or any change which needs a table drop and recreate,  you might get this error message :

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 recreated or enabled the option Prevent saving changes that require the table to be re-created.

Basically, there is a small setting that you need to do before this, to have it work.

Go to Tools -> Options -> Designers  -> Uncheck the option “Prevent Saving Changes that require table re-creation

This will rebuild the table , and generally it isn’t worth the hassle if the table is at all large and will make deployment to production trickier.

SQL Server 2008 - Options

Tools -> Options -> Designers you would need to uncheck the option "Prevent Saving Changes that require table re-creation"

Advertisements

About mytechlifedays

Its been a wonderful learning period over the last 6 years in the IT industry , getting exposed to whole lot of technologies and ideas. The hurdles and the crisis that came along have been wonderful experience ... And now its time to pen them down so that let some others execute faster and easily with these information .....
This entry was posted in Database and tagged , . Bookmark the permalink.

Leave a Reply ! It would be always appreciated ! :)

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