Intermittent timeout when running a stored proc through VB.net code
Posted on 2013-11-18
I am running a stored proc (which has about 20 update statements in it) through VB code. Sometimes it works fine...other times it times out. The only out of the ordinary thing that is going on is that there are many more update statements than a typical stored procedure. Those statements are quite simple though and there are only a few thousand rows being dealt with at any one time.
I'm running VS2012 against SQL Server 2005. Also, in testing, one specific set of inputs may work then fail...or fail, then work (or fail, fail, fail, then work)... no consistency there.