SQL Server 2008 Manual modification of table structure, table cannot save problems and solutions _mssql2005

Clicking "Save text File" will pop up the dialog box that saves the text file.

The contents of the saved text file are as follows:

/*
April 5, 2010 0:34:53
User:
Server: Longgel
Database: Longgel
Application:
*/

Childcaiclass

Saved for me is simply useless information, just recorded the occurrence of the transaction time and some relevant information, the result of this operation of the database structure is still not able to modify and save, but continue to pop up the window, which I am depressed.

Click "Cancel" but pop up

It is also a saved result that does not complete the table modification. I think it's a little uncomfortable. Fortunately, my first time to consider is not the problem of setting. It doesn't take me much time to solve the problem. (: To be honest, with SQL server2005 never need to do this, before saying that the general situation of the project is to manually write add script and modify the script, just met this result is really a bit depressing. I will tell you the solution.

In the Options menu under the SQL Server 2008 Tools menu, in the pop-up dialog box, there is a "designers" in the list on the left, and click OK to cancel the save request to recreate the table changes check box. You can complete the modification of the table structure. As shown in figure:

To be honest, I've used SQL Server 20,081 for a while, because the project needs to be written in a script to modify the table structure, and I really don't see the problem. I think you should still be in the mainstream of SQL Server 2005, and today we are also bold to put the solution to the problem on the home page, so that everyone in the use of SQL Server 2008 in the face of this situation. I also hope that when you encounter some problems, you will also record their own solutions to share, but also to their own in the face of this problem when you forget how to operate when there is a page to look up the location of information.