[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