using stored procedure...

Results 1 to 2 of 2

Thread: using stored procedure...

  1. #1
    Join Date
    Dec 1969

    Default using stored procedure...

    i would like to start a stored procedure by an ASP, but the stored procedure duration is too much. Could i drop down the connection to server continuing run the stored procedure or could i close the ASP executing stored procedure?

  2. #2
    Join Date
    Dec 1969

    Default RE: using stored procedure...

    the connection object keeps the connection open until it gets a response from the SP. You could try to break the SP into multiple parts.<BR><BR>Hmm, maybe you could start an Job that executes the SP, I don&#039;t really know if that&#039;s going to work but at least you could try.

Posting Permissions

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