SQL Server-Fix sqlserver2008 "Prevent saving changes that require table re_creation (prevent saving changes requiring re-creation of tables)" issue

The computer re-installed sqlserver2008 R2 (English), New data table, new field, found that there is a field type set wrong, want to modify the field type, and the table has been saved, that is, after saving to modify the field properties. However, the modified settings cannot be saved, prompting "saving changes is not permitted" (specifically)

Workaround:

Find the Tools->options in the menu bar, find the designers, and then prevent saving changes that require table re_creation front of the tick, save it.

If the Chinese version is a tool-and option, then remove, save, and restart SQL Server by removing the "prevent saving changes that require a table to be recreated" check box.

SQL Server-Fix sqlserver2008 "Prevent saving changes that require table re_creation (prevent saving changes requiring re-creation of tables)" issue