SQL Server Error: Timeout expired

Last Reply on Mar 11, 2018 11:57 PM By kalpesh

Posted on Mar 11, 2018 11:41 PM

when I run the storeprocedure which made using while function it takes long time and timeout expiration occured each time when i run the storeprocedure in vb.net.

How to solve this whithout changing sql timeout options

Posted on Mar 11, 2018 11:57 PM

If your stored procedure having loop and based on their iteration if time elapsed then you cannot change for time out expiration without changing SQL timeout option as it’s based on your SQL query execution time and timeout expiry limit.
Refer the below link for your reference to set SQL Timeout option.

SQl Server still getting the error of “Timeout expired. The timeout period elapsed”