title: Find out the calling stored procedure in SQL Server
body: <p>Is it possible to find out who called a stored procedure?</p>
  <p>For example, say I get an error in <code>proc3</code>. From within that proc I want to know if it was called by <code>proc1</code> or <code>proc2</code>.</p>