an asp page of mine with server.ScriptTimeout=540 seconds
this page is then executing a select query from a huge database table which is properly indexed

few times there is a SQL timeout because of conditions passed in query

is there a way to handle the SQL timeout and display a user friendly message to the user to refine the search conditions.

            dim adocon
            set adocon=server.CreateObject("ADODB.Connection")

            dim rs
            set rs=server.CreateObject("ADODB.Recordset")
   "my query goes here", adocon

my Server:
- Windows Server 2008
- MS SQL Server 2008 R2

As you may already know, ASP doesn't provide a try...catch block for you to trap errors.

The closest approach would be something like this...

On Error Resume Next 
code that can fail here.........

If Err.Number<>0 Then
   Response.Write("an error has occurred. Description: " & Err.Description)
End If
commented: Thanks. Yest thats the only way. +0