asked
Can the line of codes inside a Stored Procedure run Multi-threaded ?
I have a parent procedure, which runs the Several(40) child procedures inside. These child procs can run independently, parallel and asynchronous. Is there any mechanism in SQL server which helps me to run this asynchronous. Any help appreciated Thanks, Noble.
This can be achieved by having SQL jobs started instead of calling SPs - as there's no way out-of-the-box that you can async call a SP. The downside is that often the user calling the proc doesn't have permissions to run sp_start_job. Another way would be to write a value to a table, and have a scheduled job that checks every x minutes for a value and then run the subsequent SPs. Neither seem clean and succinct approaches. Other approaches can involve Service Broker or MSMQ to place a 'request' on a queue.
14 People are following this question.
