Stored procedure time out

Topics: Data Access Application Block
Jan 22, 2013 at 3:49 PM

I am using enterprise library 5 and calling one stored procedure. My one particular stored procedure call is timing out but as soon as time out happens I get result set appeared in profiler running on SQL server. When I run the procedure directly it is working fine without any issues. Only through code it is behaving differently.

What could be the issue.

Jan 23, 2013 at 3:15 AM

The usual culprit is the parameters being sent to the stored procedure are not as expected which causes the stored procedure to take a long time.  Have you run SQL Server Profiler on the database while executing the code and seeing what is going on?

--
Randy Levy
entlib.support@live.com
Enterprise Library support engineer
Support How-to 

Aug 20, 2013 at 2:27 AM