I have an asp.net page that runs a stored procedure on SQL Server 2000. The trouble is that the query can take over a minute to run and I get the following exception:
"System.Data.SqlClient.SqlException: Timeout expired."
What I want to know is:
- How do I display a "Please wait we are processing your request..." notice while the query is running.
- How do I increase the timeout from the 30 second default.
I have tried but without success.