Run database procedure in background

[tcstom]

I have a SQL Server stored procedure that takes a long time to execute. I want to allow users of a ASP.NET web form to execute this stored procedure but to have it run in the background rather than have the page wait for it to complete. Is there a way to do this?

 

[onpnt]

You can start another thread that executes the procedure

_{____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done}

 

[Kalisto]

Run it asynchronously, but is the sproc running anything that ought to report back to the user?

If so, I'd say you need to rethink your approach.

How long is the sproc taking, and why does it run so slow?

 

[tcstom]

It runs slow because it does a hell of a lot! Essentially re-builds a reporting database from live data. Thanks for the feedback guys. Haven't used threads before but looks like now is the time to look into it...