title: Get application name that executes specific stored procedure
body: <p>I want to know the application name that executes a specific stored procedure. We have many applications and all have application name property inside the connection string. </p>
  
  <p>Here I don't exactly know which application calling that stored procedure. I think we can get this by calling <code>APP_NAME()</code> but I don't know the exact query to get the correct application name.</p>
  
  <pre><code>SELECT APP_NAME() 
  </code></pre>