SQL Server Timeouts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What could the possible reason be for obtaining "timeouts" when executing a
stored procedure from my application? If I execute the specific stored
procedure in Query Analyzer I do not get any timeouts and the stored
procedure takes approximately 30 to 40 seconds to execute.
 
the default commandtimeout is 30 seconds.

you need to adjust it.

CommandTimeout

...

NOTE
Connection Timeout is NOT the same thing as Command Timeout.
 
Back
Top