Timeouts on a stored procedure problem

Thread: Timeouts on a stored procedure problem

Search this list only Search all lists
Timeouts on a stored procedure problem
	2007-01-26 07:42:00
My application(windows service) is calling a Stored procedure, which normally does not take too much time to run on a query analyser. The Application windows Service starts in the morning every day and starts timing out continuosly on this stored procedure. The stored Procedure does some select and returns a data set back. Here is the way I get over it ...I go to the stored procedure and put in another clause there to pick up only one record by hardcoding a value of the index column, so this becomes faster. At this time the application stops timing out on the stored proc and now if I remove the hardcoded clause it still runs absolutely fine for the rest of the day. Does anyone know the reason or solution to this problem? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to TechdotNetIndiagooglegroups.com To unsubscribe from this group, send email to TechdotNetIndia-unsubscribegooglegroups.com For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en -~----------~----~----~----~------~----~------~--~---