Hi,
It look that the SQL server take more time to search the data that before, check the indexes -it look like the search doesn't have index key- or why it take more time to get the information, do the same test using Server Query Analyzer.
What SQL version are you using?
Gerardo

>Hi! My script has been running for more than a month now and users have been accessing it everyday in our intranet. But yesterday, we encountered the ff. error:
>
>Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
>
>[Microsoft][ODBC SQL Server Driver]Timeout expired
>
>/eodcacdcc/agingneg.asp, line 152
>
>I am using a ADODB.Recordset.
>
>This line is:
>
>db_rs.open dbf_qry, "DSN=my_sql;UID=sa;PWD="
>
>where dbf_qry = "Select ..."
>
>This has been working for more than a month everyday. What happened. Can anyone give me some pointers on this? I would really appreciate the help since a lot of ppl. are now unable
>to access this particular asp page.
>
>Thanks
>
>Ramon Carlos