开发者

What error numbers can be returned by SqlCommand.ExecuteXXX() when timeout occures

开发者 https://www.devze.com 2023-03-08 03:16 出处:网络
I need to handle timeouts when executing SQL s开发者_如何学运维tatements in C#.For handling deadlocks I would look for error code 1205.I am wondering what error codes I need to look at when looking fo

I need to handle timeouts when executing SQL s开发者_如何学运维tatements in C#. For handling deadlocks I would look for error code 1205. I am wondering what error codes I need to look at when looking for timeouts. Querying the messages table of SQLServer for error messages containing the term 'timeout' I get beck somewhat around 30 records. Which of those are relevant for SqlCommand.ExecuteXXX()?


Timeout is -2: it doesn't come from SQL Server itself but your client drivers.

0

精彩评论

暂无评论...
验证码 换一张
取 消