[Sql] Asynchronous Stored Procedure Calls
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.
According to this question you could try using the Service Broker
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/
Yes, it's synchronous