Saving changes is not allowed. Your changes require that the following tables be deleted and recreated. You have made changes to the label that cannot be recreated or enabled "prevent saving changes that require the table to be recreated"

Recently in the process of using sql2008, to have created the completion of the table structure to modify, but has been prompted to pop up the following prompt:

“

Saving changes is not allowed. Your changes require that the following tables be deleted and recreated. You have made changes to the label that cannot be recreated or enabled "prevent saving changes that require the table to be recreated"

”

At first I thought it was because I was too much in the home and the company's machine to use the database caused by the version of the problem, but the final confirmation is not a version of the problem, after searching, found the corresponding solution:

“

Open the SQL SERVER 2008 Tools--Options-->designers--> Table Designer and Database Designer, remove the check "prevent saving changes that require re-creation of tables" and click OK.

Saving changes is not allowed. Your changes require that the following tables be deleted and recreated. You have made changes to the label that cannot be recreated or enabled "prevent saving changes that require the table to be recreated"