This example shows how to write a T-SQL script to execute a SP asynchronously, where control is returned to the calling T-SQL code prior to SP code completing.
 read more ...