Stored Procedure & ScriptTimeOut

Results 1 to 2 of 2

Thread: Stored Procedure & ScriptTimeOut

  1. #1
    Bikash Panda Guest

    Default Stored Procedure & ScriptTimeOut

    I have a Stored Procedure which runs for 40 Minutes & is tested fine in SQL Query Analyser. I need to call this SP in my ASP page which times out before the SP executed completely. I tried setting Server.ScriptTimeOut to 2400 but nothing resulted.<BR>Any help/suggestion in this regard is appreciated.<BR><BR>Thanks<BR><BR>Bikash<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure & ScriptTimeOut

    Change the commandtimeout and connectiontimeout properties of the command/connection objects and see if that helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts