When a large amount of data is MSSQL, saving changes after indexing or adding fields----time-out------

Generally we like to use the database Manager UI to make changes to the data table structure, and then naturally place the "save" button to save, but when the amount of data is relatively large, the use of this trick will often appear "Cannot create INDEX" IX_ index name. The timeout period has expired. The time-out elapses before the operation completes or the server is not responding. "This error. At a loss, Waxman Zhang's article http://www.cnblogs.com/waxdoll/archive/2006/03/24/357972.html, after the comments gave me guidance. Thank!

It's easy to sort out the specifics, but when no one teaches me to do this, it's only despair:

In changing the data volume of the table data structure, do not click the "Save" button, but the table structure edit box to the left of the right-click = = = "Select Generate Change Script", then out of the Text dialog box, the contents of the full selection and copy, and close the table, choose not to save, right click on the table belongs to the database Ctrl + V then glue the newly copied script in and run. This will never pop out of the hint, if the amount of data is quite large, we just need to wait patiently!

Reprint Address: http://blog.csdn.net/cpcpc/article/details/6278537

When a large amount of data is MSSQL, saving changes after indexing or adding fields----time-out------