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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exception: Timeout expired 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Nesting SQL Server 2005 transactions in VB.NET 2
Executing a stored procedure that uses linked server from vb.NET 4
Oracle Data Provider for .NET: Connection request timed out 0
Problem in setting Timeout 1
DataAdapter.Fill(Dataset) shows timeout error. 2

Back
Top