SQL Server Management Studio in SQL Server R2 2008 prevents the Setup method from saving changes that require re-creation of tables

In 2008, the option to block saving changes that require the table to be recreated is added. Symptoms are "blocking" you when modifying the table structure.

The solution to the " prevent saving changes that require re-creation of tables " in SQL Server"is the main thing we want to introduce in this article: when we have finished building the table with SQL Server 2008, we insert or modify any column, Tip: When a user changes the table structure in SQL Server 2008 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:

The workaround for SQL Server 2008 "Prevent saving changes that require re-creation of tables" is as follows

If you want to get rid of this hint, open SQL Server Management Studio in SQL Server R2 2008, and in the top toolbar, locate tools.

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 .

Then save again, everything OK.

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.

SQL Server Management Studio in SQL Server R2 2008 prevents the Setup method from saving changes that require re-creation of tables