Posted by Erland Sommarskog on 07/03/06 22:05

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.

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]