|Reading time|||0.13 minutes||word count|||223.2 characters|
|primary coverage|||1. Introduction & background|
|『MSSQL·Execution Timeout Expired. The timeout period elapsed prior to completion of the oper..』|
|Author||| SCscHero||Writing time||| 2021/7/17 PM4:7|
|motto||Every great cause has a trivial beginning.|
1、 Introduction & background Completion: 100%
a) Coping with problems
In MSSQL, an error as shown in the figure: execution timeout expired. The timeout period elapsed prior to completion of the operation
b) Coping scenarios
In MSSQL, GUI interface changes table design or other operations.
c) Solution principle & method
[solution principle]Some operations lead to table reconstruction, that is, the bottom layer will create a new temporary table for transfer back writing and other operations, which is very slow in the case of large amount of data, resulting in timeout.
[solution]To open the designer (Design) in the “tools” – > “options” menu, change the “connection string timeout value updated by overlay table designer”, and set the “transaction timeout after timeout” time. The valid values are 1-65535.
2、 Statement and references Completion: 100%
Original blog, please do not reprint without permission.
If you have any help, you are welcome to like, collect and pay attention. If you have any questions, please comment! If you need to contact the blogger, you can directly send a private message to scscshero.