[dba-SQLServer] Timeout

Stuart McLachlan stuart at lexacorp.com.pg
Thu Aug 19 17:14:43 CDT 2004


On 19 Aug 2004 at 13:38, John W. Colby wrote:

> 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.

Are you running this from the Query Analyzer or an Access (or whatever) FE  
using OBDC.  If the later, go into the ODBC Manager in you Control Panel

Also, try Count(*) rather than specifying a field.

-- 
Stuart





More information about the dba-SQLServer mailing list