BlankSometimes, when large tables are being queried via the MMC in =
Enterprise Manager, an error is returned because of an SQL ODBC driver =
time-out.=20
The same query when run from the Query Analyzer is completing =
successfully. Is there a parameter that can be modified to increase the =
time-out of the SQL ODBC driver?

The issue you are experiencing is similar to the one
described in the following article:
BUG: Opening a Long-Running View from SQL Server Enterprise
Manager Gets ODBC Timeout
http://support.microsoft.com/?id=247070
As the article indicates, it's not a good idea to open long
running queries in Enterprise Manager. The solution is to
use Query Analyzer instead. Enterprise Manager was designed
more as an admin tool, not a client data tool.

-Sue

On Thu, 13 Jan 2005 08:43:55 +0200, "Imad Koussa"
[quoted text, click to view]