Timeout during Async SQLServer batch

A

Alan Z. Scharf

1. I have a set of six async calls to SQLServer2000 SP's.

2. These six SP's run fine in SQLServer Query Analyzer when called from a
master SP executing the individual SP's in succession.

3. However, when executing these SP's in async fashion from a web form, the
process times out after about 60-65 seconds. The length of the entire
process will vary according to a date range set by choosing a date from a
dropdown. But it always stops processing at a date range which takes over
65 seconds. There are no error messages coming up.

4. I tried setting the Server.ScriptTimeout setting to 600 in the button
that starts the entire process, but that's probably not the right thing to
be setting.

5. What other timeout settings would be relevant?

Thanks very much.

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top