Posted by Madhivanan on 07/05/06 13:29

http://vyaskn.tripod.com/watch_your_timeouts.htm
http://vyaskn.tripod.com/sql_odbc_timeout_expired.htm

Madhivanan


Cimode wrote:
> You need to do some tuning...
>
> Erland Sommarskog wrote:
> > Brad (bmeyynospamnospam@bmegroup.com) 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@sommarskog.se
> >
> > 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

[Back to original message]