SQL Server 2008 Block Save setting method that requires a change to recreate table problem

It is not very clear why the option to prevent saving changes to the table is required in 2008. The symptoms are "blocking" you when you modify the table structure. And I met the situation is actually sometimes stop you, sometimes do not stop you, can not touch the mind.
The solution to the error of SQL Server 2008 "Prevent saving changes that require re-creation of tables" is what we are going to focus on in this article: when we have built a table with SQL Server 2008, we are prompted when inserting or modifying any column: When the user is in SQL Server 2008 When you change the table structure in Enterprise Manager, you must first delete the original table and then recreate the new table to complete the table changes.

If you make a forced change, the following prompt appears: Save changes are 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 the "Prevent saving changes that require table re-creation" option. Such as:

If you want to remove this hint, open SQL Server 2008 on top.

Workaround:

Tool-〉 Options-〉 a designer-〉 Table Designer and Database Designer on the left to prevent changes that require re-creation of the table (right) remove the hook.

About the workaround for SQL Server 2008 "Prevent saving changes that require re-creation of tables" is introduced here, I hope this introduction can have a harvest for you!

It is recommended that the friends of the Beginner database cancel this option when they are in use, by looking for "tools" on the menu bar in Management Studio and clicking on the options below, expand designers in the interface below, select "Table Designer and Database Designer", and " Prevent saving changes that require re-creation of the table "before the tick is knocked out.

Finally, the point is that this option is under "Tools" on the menu bar, and it is important to emphasize that I have found the wrong place several times.