Re: SQL Server 2000 query time out option, what does it do?

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Sat, 28 Jan 2006 17:16:16 +0000 (UTC)

Robert (robert.j.sipe@xxxxxxxxxx) writes:
> Can anyone tell me what the query time out is for? It is not acting as
> I would exepct

The query timeout is for queries to remote servers. I will have to
admit that I have not investigated the option in depth, although we
have had cases at work where we have run into such timeouts.

What are your expectations?

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Follow-Ups:
- Re: SQL Server 2000 query time out option, what does it do?
  - From: Robert
- Re: SQL Server 2000 query time out option, what does it do?
  - From: Doug

Prev by Date: Re: What is the right datatype to store Hours up to the minute precision?
Next by Date: SQL Server client tools
Previous by thread: How to find first not null value in column
Next by thread: Re: SQL Server 2000 query time out option, what does it do?
Index(es):
- Date
- Thread

Relevant Pages

Re: Inserted row after DB_E_ABORTLIMITREACHED
... A query timeout means that the API got tired of waiting for results ... API you use. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.data.oledb)
Re: Limit query execution time
... mention the version of SQL I am using: ... But I remember now that there was a weird bug with the query timeout in SSMS 2005. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Computer Columns
... A computed column is not stored on disk unless an index is created on ... it will be calculated at query time if there is no index. ... Looking for a SQL Server replication book? ... > computer at time of viewing, or is it computer as soon as the row is ...
(microsoft.public.sqlserver.server)
Re: REPLICATION ERROR - retention-based meta data
... I want to increase query timeout value but I don't how to do this. ... > SouRa, ... > Paul Ibison SQL Server MVP, ...
(microsoft.public.sqlserver.replication)
Re: Sql Query
... We dont have an SQL server - we have an AS400 running ... Where can I download osql.exe? ... >Use osql.exe in your batch, ...
(microsoft.public.win2000.cmdprompt.admin)