title: why Temporary tables not remove after completed their scope?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6623846/why-are-temporary-tables-not-removed-from-tempdb-in-sql-server">Why are temporary tables not removed from tempdb in SQL Server?</a>  </p>
  </blockquote>
  
  
  
  <p>We have created Temporary tables in a stored procedure and while running the stored procedure the Temparory table is created in the TempDB.</p>
  
  <p>In my SP I have written code to drop that temporary table after completion of all operations manually.</p>
  
  <p>But it is still there in the TempDB and not dropped. But when I restarted the SQL connection then the table had been dropped. I don't understand how this type of scenario happen in my DB.</p>
  
  <p>Why are my temporary tables not dropped after completion of their scope?</p>
  
  <p>Can anyone help me out this problem?</p>