Colby, John
JColby at dispec.com
Wed Aug 25 09:24:30 CDT 2004
The query analyzer does indeed work fine where EM times out. Strange but true. JWC -----Original Message----- From: John Maxwell @ London City [mailto:John.Maxwell2 at ntl.com] Sent: Thursday, August 19, 2004 1:58 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] Timeout I also get this problem using the query builder in EM but fine when use Query analyser If in rush for results may be worth switching while waiting for a proper solution to be posted. Regards john -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: 19 August 2004 18:39 To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Timeout I am trying to run a simple count query on this big db I'm building. The SQL is SELECT COUNT(ID) AS Cnt FROM dbo.Conduit Which is built by the query builder in EM. The query times out. [Microsoft][ODBC SQL Server Driver]Timeout Expired. Anyone have a clue where I go to increase this value so I can get a count. ID BTW is the "autonumber" PK. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com