Unanswered: Running a MsSQLServer Stored Proc thru ASP
I want to run a MsSQLServer Stored Proc thru ASP.
Simple, right? Sure, I was able to achieve upto this.
The problem starts here:
The procedure might run for several minutes and I don't want the user to keep waiting for the prompt to come back. Once they press the Submit button, it should start off the store procedure and return the control back to the user so that he can do other activites if needed.
Is there a solution. Any help i highly appreciated.