How to run Sql Server stored procedure in Async mode?
The simplest way is to call sp_start_job and kick off an unscheduled SQL Agent Job.  Parameter values can be stored in a table that the job reads from before calling the procedure.