[dba-SQLServer] Timeout

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