title: if a proc has last step as starting another proc does the first proc wait for the other one to finish before finishing?
body: <p>So I have this proc that does a bunch of delete and inserts and then on the last step it starts another proc on a different server. 
  My question is: Does the first proc waits for the second proc to finish ? or it just starts the other proc and done ? 
  Because I keep getting sql time out in my vb code and not sure if that could be the reason </p>