The select won't return the results to your current SSMS window. The system will run the sql statements in their seperate SPIDs. So you'll see nothing.

The typical scenarios is...

This system itself put tiny little load to database server. The real loads come from...

mike 57299 (2/27/2014)

---

Hi.

This is a great function. Can you tell me if the system uses one database file for this function? I have created separate...

Robb Melancon (5/10/2010)

---

Thanks for the reply. The only problem with using temps is that they would need to be global or declared directly in temp database like you said....

Robb Melancon (5/7/2010)

---

I like the tool, however is there anyway to have it return rows? I have a need to execute multiple sprocs in parallel but these procs return...

Try this:

Execute T-SQL Scripts in Parallel

http://www.sqlservercentral.com/scripts/T-SQL/68002/

If you simply sp_exec in loops, notice still they (many worker spids) are all controlled by current master SPID and in theory they will all run in the same parallel...

Sorry, I haven't written a lot document yet. Do you only want to know how to call it? It's...

brownp (9/1/2009)

---

I was able to clean the text and implement the solution. It runs great on our 4cpu dev server. I did notice that when the SQL you...

I still have the same issue after re-submitting. Please use the trick mentioned above to copy and paste the script.

Good luck!

James

FYI --

I have re-submitted the same script "Execute T-SQL Scripts in Parallel" since I find I cannot copy and paste the code due to the Page's Unicode encoding adds...

Sorry for the inconvenience. I find the...

Another improvement that I can think out is to implement the 2PC transaction protocol. So this tool can be even used to improve performance of distributed trancations.