abandon Stored procedure

• lof

  Default port

  Points: 1498

  More actions

  August 7, 2002 at 3:06 pm

  #79171

  Hi

  Is there a way to call an stored procedure from an external application and not wait for it to complete?

  I have an SP, that runs for about 2mins, that I need to call from Access. The SP does not return anything and I do not care (whithin Access application) when it finishes. Access times out on me while running it.

  any ideas?

  Thanks,

  Jakub

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 7, 2002 at 4:02 pm

  #434234

  One way would be launch it as a job. Another would be to execute it in a timer event and then disable the timer (so it doesn't recurse). I think ADO does have some support for async execution, but have not tried it so far. If its just a time out issue, you can also consider tuning the proc or setting the timeout in the app to a longer period.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter