Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Change database timeout
- Thread starter sroz
- Start date
tlbroadbent
MIS
Generally, the timeout is set by the client. ODBC and ADO have QueryTimeout properties.
I recommend that you don't set the timeout value to 1 hour for any query. A query that runs for an hour usually need tuning and optimization. Allowing inefficient, non-optimized queries to run on your server impacts all users and server processes.
I also recommend posting Sybase questions in the Sybase forum as this forum is not for administrative questions. It deals with ANSI SQL programming. Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
I recommend that you don't set the timeout value to 1 hour for any query. A query that runs for an hour usually need tuning and optimization. Allowing inefficient, non-optimized queries to run on your server impacts all users and server processes.
I also recommend posting Sybase questions in the Sybase forum as this forum is not for administrative questions. It deals with ANSI SQL programming. Terry L. Broadbent - DBA
SQL Server Page:
If you want to get the best answer for your question read faq183-874.
- Status
