|
|
|
|
Time-out when querying large databases
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002A_01C4F94C.03EDBFC0"
------=_NextPart_001_002A_01C4F94C.03EDBFC0
Thu, 13 Jan 2005 08:43:55 +0200
"Imad Koussa"
|
Re: Time-out when querying large databases
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"
wrote:
>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.
>The same query when run from the Query Analyzer is completing s
Thu, 13 Jan 2005 09:44:47 -0700
Sue Hoegemeier
|
|