locked
timeout RRS feed

  • Question

  • Any idea how to run a sql query to set the timeout to 0?

    Thursday, February 14, 2008 1:24 AM

Answers

  • From the application, the API (ADO.NET) will have settings for timeout.

     

    From SSMS, there are settings in the Tools]Options area.

     

    Please be more specific.

     

    Thursday, February 14, 2008 1:32 AM

All replies

  • From the application, the API (ADO.NET) will have settings for timeout.

     

    From SSMS, there are settings in the Tools]Options area.

     

    Please be more specific.

     

    Thursday, February 14, 2008 1:32 AM
  • If your queries are getting timedout from your .NET application, you can set the CommandTimeout property of SqlCommand object. The default timeout is 30 seconds.

     

    As Arnie said, if you want to set the timeout of SQL server management studio, you can do it from tools->options. The default timeout is 0 which means 'unlimited'

    Thursday, February 14, 2008 2:54 AM