Run SQL Query on Different Thread of SQL

In One Stored procedure i m calling two - three different stored
procedure . Can i run sub Stored Procedure (Calling Procedure ) in
different SQL threads
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Dharmesh Doshi wrote:
> In One Stored procedure i m calling two - three different stored
> procedure . Can i run sub Stored Procedure (Calling Procedure ) in
> different SQL threads
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can kick off multiple jobs to to this. You can also call the
procedures from your app asynchronously from ADO or kick off multiple
threads if your app uses .Net.
If Proc1 calls Proc2 and Proc3, though, and I needed to run them
asychronously, I might kick them off separately from the app once Proc1
completed. Or you can create jobs in Proc1 that kick off and immediately
run Proc2 and Proc3.
David Gugick
Imceda Software
www.imceda.com