Have you check Microsoft knowledgebase site? 
There are lots of fixes for this problem. Check it out. 

 Nahid 

-----Original Message-----
From: fanos1@h... [mailto:fanos1@h...]
Sent: Thursday, June 06, 2002 7:00 AM
To: ASPX_Professional
Subject: [aspx_professional] Re: Timeout error


Hi, 

 Can anyone help me with the following error?

 When I execute the Store Procedure from the QUERY ANALYZER it needs more 
than 15 minutes to be executed without any errors.

However when I'm trying to run it(is quite big because it calls several 
functions)I have the following error messages: Timeout expired. The 
timeout period elapsed prior to completion of the operation or the server 
is not responding, or the maximum pool size was exceeded.

* Something else also:
When I debug the Store Procedure from the Query Analyzer I have the   
following error message:[Microsoft][ODBC Sql Server Driver] [SQL Server] 
Unable to communicate with debugger on SQLTESTBED 
(Erro=0x80004005).Debugging for connection 68.


Can anyone advice possible solutions?
Thanks in advance.
F.