title: SQL 2008 R2 : Could not find stored procedure
body: <p>I am studying the SQL procedure.<br>
  I created a procedure and I execute. I was fine... and.  it displayed  </p>
  
  <blockquote>
    <p>Could not find stored procedure when executed "exec my_procedure"</p>
  </blockquote>
  
  <p>I am not really sure the reasons I am getting this error.  Did I choose the wrong directory to store the procedure? </p>