title: Increase maximum recursion depth when querying table-valued function
body: <p>I am calling a recursive table valued function like this:</p>
  
  <pre><code>SELECT * FROM dbo.Some_TVF(@param1, @param2)
  </code></pre>
  
  <p>I receive the following error:</p>
  
  <blockquote>
    <p>Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).</p>
  </blockquote>
  
  <p>It turns out the data is such that it needs to go deeper than 32. Is it possible to change the depth for this single call?</p>
  
  <p>Edit: BTW, this does not work:</p>
  
  <pre><code>SELECT * FROM dbo.Some_TVF(@param1, @param2) OPTION (MAXRECURSION 100)
  </code></pre>
  
  <p>Even when I specify the <code>MAXRECURSION</code> hint I still get the same error message (with limit 32).</p>