Asynchronous Stored Procedure Calls [sql]
With MS Sql Server 2005, try the Service Broker and/or CLR stored procedures. I don't think there's anything built directly into TSQL.
Is it possible to call a stored procedure from another stored procedure asynchronously?
Edit: Specifically I'm working with a DB2 database.
Launch multiple stored procedures to run 'in the background' on SQL Server Express Edition
It is possible in SQL 2005 and later. Have look at http://rusanu.com/2009/08/05/asynchronous-procedure-execution/
According to this question you could try using the Service Broker
Yes, it's synchronous