Problem in setting Timeout

8 May 2006 4:26 AM

Ramakrishnan Nagarajan

Hi,
In my application I am using several Stored Procedures written in MS-Sql
Server. Of that one SP takes much time to execute. Because of that, one of my
pages using that SP is throwing Timeout Expired Error. The SP is optimized is
the saying by my DB Team. So now I need to counter that error in my page
only. Is there any possible approach for that issue by setting Time out for
that particular page. So that, I may extend the life of that page a little
longer. Please help me in solving this issue.

Thanks in Advance,
N.Ramakrishnan

9 May 2006 12:59 PM

GÃ¶ran Andersson

Use the Server.ScriptTimeout property.

Ramakrishnan Nagarajan wrote:
Show quoteHide quote

> Hi,
> In my application I am using several Stored Procedures written in MS-Sql
> Server. Of that one SP takes much time to execute. Because of that, one of my
> pages using that SP is throwing Timeout Expired Error. The SP is optimized is
> the saying by my DB Team. So now I need to counter that error in my page
> only. Is there any possible approach for that issue by setting Time out for
> that particular page. So that, I may extend the life of that page a little
> longer. Please help me in solving this issue.
>
> Thanks in Advance,
> N.Ramakrishnan