Hi,
---THIS IS FOR SQL 7, please confirm for 2000.---
queries time-out after 25 times the expected time for SQL to perform the task. You also can specify the "query wait" with sp_configure from 0 to 2147483647 sec. Remember that configuration is for the server! -1 is the default value - for 25 times SQL plan.
If you use a Stored Procedure, you can handle the error with @@error rigt after the select, otherwise you can handle it in the page code, checking the error returned by SQL.
🙂
Foca.