title: How to execute a sql server stored procedure asynchronously and ensure it's completion
body: <p>I have a stored procedure that when called does a large amount of processing.  Various parts of the stored procedure are wrapped in their own transactions but, the entire proc. does not run in a transaction as this would cause unnecessary blocking and harm performance.  The problem I have is that if a user closes the user interface after the proc. has started and before it ends, the connection closes and the proc. stops executing.</p>
  
  <p>Is there any way to do this asynchronously or in another process that won't abort if the user interface application is closed during processing.</p>