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-06-18 : 09:33:06
|
Jim writes "I have a report running on ASP calling a Stored Procedure on a SQL Server Database. The Stored Procedure calls a view. The view accesses several tables. This stored procedure is taking up to 20 minutes to return some querys and 30 seconds for others. Are there any ways to prevent this timeout from happening?
Below is what the webserver returns.
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver]Timeout expired
/DAISy/downloadReport.asp, line 127
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
Page:
POST 54 bytes to /DAISy/downloadReport.asp
POST Data:
assetOrgs=6&assetLocs=147&assetReport=Get+Asset+Report
Time:
Thursday, June 14, 2001, 2:45:35 PM" |
|
|
|
|
|
SQL timing out