How to fix the SQL Server table structure when the timeout time has arrived

Background: Recently modified a SQL Server table structure with large amounts of data, error "cannot modify table." Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding. 】

Resolution: Tools, Options > Designer, Table Designer, and Database Designer, check the "Timeout for Table Designer update override connection string", and the "Transaction time-out" by default should be 30 seconds, which is slightly larger, But it doesn't seem to be more than 65535.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/86/9C/wKiom1fFR2WAB_x5AABTAuvE57M228.png-wh_500x0-wm_3 -wmp_4-s_2277483159.png "title=" qq picture 20160830164302.png "alt=" Wkiom1ffr2wab_x5aabtauve57m228.png-wh_50 "/>

 

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1844388

How to fix the SQL Server table structure when the timeout time has arrived