title: How to read config file key in SQL Server 2008 stored procedure
body: <p>I have a settings.config file in my <code>c://config</code></p>
  
  <p><code>settings.config</code> has this contents:</p>
  
  <pre><code>&lt;filelocation&gt;d://mydata&lt;/filelocation&gt;
  </code></pre>
  
  <p>Now I want to get <code>d://mydata</code> file path in my SQL Server 2008 stored procedure, which will take this location as input for file creation path.</p>
  
  <p>Please suggest!!</p>