Hi guys, we've moved to a new server last week. We have a stored proc which is run through WSI ipx.asmx and we're now getting a timeout error for the response:
<Error Message="Exception, Message=Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."/>
Running the actual sp in SSMS it takes 50secs, so I changed the ExecuteSQL to ExecuteLongTimeSQL(sql,100) but still get the error.
It's probably a setting that I changed years ago, but can't remeber/find it now.
Also added <add key="SQLCommandTimeoutSecs" value="120" /> to AppSettings.config
Any ideas how to overcome this please