Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smccreadie
Aged Yak Warrior
505 Posts |
 Posted - 2001-10-11 : 11:56:02
|
| I've got a complex stored procedure that I'm firing from ADO/ASP. The SPROC populates some tables that I want to reference later. I also enter a record in a queue table at the start of the procedure and flip the flag to completed at the end.The run time is 1-2 minutes depending on some parameters that are passed in. This exceeds the default 30 second timeout and causes an error.I want to fire off the stored procedure and redirect the users to a "Please Wait" page. That page will periodically check the queue table. When complete, the data will be displayed.My questions is:What's the best way to fire a stored procedure with parameters and send the page elsewhere while the SPROC runs? I tried the response.redirect but that doesn't work until the SPROC finishes. Is there a way to call these things outside of ADO? |
|
|
|
|
|
avoiding timeout errors in ADO