469,934 Members | 2,132 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

SQL Server Timeouts

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.
Jan 30 '07 #1
2 1125

the default commandtimeout is 30 seconds.

you need to adjust it.

CommandTimeout

...

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


"Connull" <Co*****@discussions.microsoft.comwrote in message
news:E8**********************************@microsof t.com...
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.

Jan 30 '07 #2
Thanks for the info. Can I set the Command Timeout if I am using a
Dataprovider?

"sloan" wrote:
>
the default commandtimeout is 30 seconds.

you need to adjust it.

CommandTimeout

...

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


"Connull" <Co*****@discussions.microsoft.comwrote in message
news:E8**********************************@microsof t.com...
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.


Jan 31 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by wamatt | last post: by
2 posts views Thread by mircu | last post: by
2 posts views Thread by Bernie Yaeger | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.