MSSQL·Execution Timeout Expired. The timeout period elapsed prior to completion of the oper..

Time:2021-7-23
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
Article type |Series Completion |Completed
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

MSSQL·Execution Timeout Expired. The timeout period elapsed prior to completion of the oper..

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.

MSSQL·Execution Timeout Expired. The timeout period elapsed prior to completion of the oper..

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.