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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-08 : 22:09:29
|
Brett writes "Okay so this sounds simple enough. I've got a large stored procedure that does several updates and deletes but nothing too excessive - maybe 10 statements. I'm executing this from an ASP page. My problem is that it times out before it completes the stored procedure. The exact error I get is:
Microsoft SQL Server Driver Timeout Expired
I've never seen this timeout error for the 'sql driver' but I did try bumping up my connection and script timeout but that didn't work. This maybe more of an ASP question than a SQL one but it's driving me nuts! Should I be executing this some other way? Are there other timeout variables that I can set?
I really do hope that this DOESN'T stump you because I'd really like to know!!" |
|
|
|
|
|
Stored Procedure times out before it completes