SQLServer2008 not allowed to save change error resolution _ do not allow saving changes, do not allow table modification _ Baidu Experience

SQLServer2008 not allowed to save change error resolution

When you run SQL Server 2008 today, you are prompted not to allow changes to be saved, and your changes require that you remove and recreate the workaround for the following table.

Tools/Materials

• Computer
• Sql server

Method/Step

1. Start the SQL Server Management Studio Tools menu, Options open Options dialog box

2. Left directory tree Select Designer to uncheck the right "block save changes requiring re-creation of the table".

3. In other versions of the "designer" entry for English "designers"

4. Click OK to set up, with ctrl+s can normally save the table structure changes.

   END

Precautions

• If you want to change back, you will have to restart Management Studio to take effect after you have changed.

SOURCE Baidu Http://jingyan.baidu.com/article/fdbd4277fa28d5b89e3f4827.html

SQLServer2008 not allowed to save change error resolution _ do not allow saving changes, do not allow table modification _ Baidu Experience