Timeout expired (0) Error

[Yale]

***how do i solve the following error?:

TrackingID=68F9A4C263FEF8A8 764.SD_ICBAM V1.0.90.CDatabaseSvc.ExecuteQueryEx.0> error '80040e31'

Timeout expired (0) Timeout expired vsSQLStatement=sp_approveContentReport_KCNet

/ProcessRequests.asp, line 140


***line 140 refers to the following:

recordsProcessed = dbsvc.ExecuteQueryEx(transactionType,sqlcommandtype, _
sqlStoredProc,connectstring, Array( sReportType, dtStartDate, dtEndDate, sLocation, sSpecialty, sFirewallID, "1"))

 

[SQLSister]

More than likely your SQL is inefficient, possibly using some poor practice such as a cursor. Or it is caught in an unending loop. Another cause can be if there is a deadlock inthe system or if the system is doing something else that is taking up all the resources.

Post your query or stored procedure and we can possibly help you improve the speed.

Questions about posting. See faq183-874

 

[Yale]

hmmm... can i just set the command timeout "within" the stored procedure itself? is that possible? if yes, how?

thanks,
yale

 

[SQLSister]

BAd idea, you need to fix th code.

Questions about posting. See faq183-874