title: Temporary table not created from dynamic query execution
body: <p>If I run this dynamic query:</p>
  
  <pre><code>declare @test nvarchar(1000) = 'select * into #tmp7 from bauser'
  execute(@test)
  </code></pre>
  
  <p>and then try to query <code>#tmp7</code> with:</p>
  
  <pre><code>select * from #tmp7
  </code></pre>
  
  <p>error is thrown:</p>
  
  <blockquote>
    <p>Invalid object name '#tmp7'.</p>
  </blockquote>
  
  <p>However if I run the same query manually:</p>
  
  <pre><code>select * into #tmp7 from bauser
  </code></pre>
  
  <p>Everything is OK. Temporary table is created and filled with results. </p>
  
  <p>Why is it not working with dynamic query execution?</p>