title: Window Service - waiting for stored procedure to get the results
body: <p>I am running a stored procedure from <code>C#</code> Window Service. The stored proc is a quite heavy query and it takes quite a long time. </p>
  
  <p>I want to wait till the stored proc finishes and return the values. </p>
  
  <p>Is there any way to determine that stored proc is finished?</p>