Re: SQL server 2000 timeout

You need to do some tuning...

Erland Sommarskog wrote:
Brad (bmeyynospamnospam@xxxxxxxxxxxx) writes:
I have been trying to do a query(view) in Enterprise Manger and Query
Analyzer with a timeout result everytime. In EM in happens in about
30 seconds and in QA it happens in about 45 seconds.

I don't think the timeout in Enterprise Manager is controllable.
It is controllable through EM...Server Property box --> connexions tab
-->Request timeout in ms...
In Query Analyzer you set it under Tools->Options->Connection->Query Timeout
(in seconds). By default it's 0, which means forever, so you would only
get a timeout if someone has changed it.

If the view refers to remote tables, you could get a timeout for the
remote part of the view, but this timeout is by default 10 minutes.


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

.

Relevant Pages

  • Re: DBPROB for Session timeout
    ... Which one of these values sets the timeout for a SQLServer-Session? ... Microsoft OLE DB Provider for SQL Server ... installed, you can test this by open a query window, put the computer ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
  • Re: Net Remoting Timeout
    ... I tried to get around the problem on an un-available remoting server bij ... using the async methods but noticed that this call is ... blocking if the remote server is not available. ... there is no way to control timeout in fw 1.1 (only on http ...
    (microsoft.public.dotnet.languages.csharp)
  • PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
    ... through a windows authentication login. ... I have tried to change the connection timeout, ... and the remote login timeout, ... The version of sql I am using is a SQL Server 2005 Evaluation edition. ...
    (microsoft.public.sqlserver.connect)
  • RE: RWW vbscript: remote desktop disconnected
    ... properties of the remote virtual web setting was set to 120 but unchecked. ... Please check the RWW timeout settings at: ... Please check ASP session timeout configuration,perform the following ... the error message "An Internal Error ...
    (microsoft.public.windows.server.sbs)
  • Re: (0x80040E31) Timeout expired
    ... hundred will run OK, but every now and again, a timeout error occurs. ... Microsoft OLE DB Provider for SQL Server ... Connection Timeout, Query Timeout or some other setting? ... Books Online for SQL Server 2005 at ...
    (microsoft.public.data.oledb)
Loading