Timeout setting to SqlServer

  • Thread starter Thread starter Zeng
  • Start date Start date
Z

Zeng

Hi,

Is there a way to increase the timeout period to Sql Server? Occasionally
my app has to run a long update and it gets timed out.

thanks!
-thinh
 
Hi,

SqlCommand has CommandTimeout property. This is what you need to change. It
affects timeout of the statement related to this command
 

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

Connect without async but get timeout error when async=true 5
Connection Timeout 1
Query Timeout Expired Using SELECT/WHERE 5
SqlClient TimeOut Issues In Asp.Net Only 7
Error: Timeout expired. The timeout period elapsed prior to comple 3
It's back - the timeout problem 8
Timeout expired - on a simple SqlDataReader:Read() call 9
Transaction and Connection Timeout 2

Back
Top