[dba-SQLServer] Timeout

John W. Colby jwcolby at colbyconsulting.com
Thu Aug 19 12:38:54 CDT 2004


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 






More information about the dba-SQLServer mailing list