Posted by Brad on 07/03/06 20:07

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 am running the query directly on a W2003SBS server with SQL Server
2000 (V 8.00.2039 )running on the server.

The message is simply
[Microsoft][ODBC SQL Server Driver]Timeout expired

I have set all the time out properties I have seen and that have been
mentioned in these forums to no avail.

I have tried rewriting several of these queries also to no avail.

I am working with a database of 140 million records and have indexed
all the pertinent fields.

I have seen some info up here about a bug in SQL 2000 that impacts EM
and not QA (Q247070), but I can't QA to work either. I seem to have
no impact on the length of the timeout. The query is not that
complicated, but does go against 140M records. I should be able to
set thetimeout longer to let this run.

Any ideas.

Thanks,
Brad

[Back to original message]