Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105032

From BetaArchive Wiki

FIX: Temporary Tables Not Dropped When Tempdb Is Full


The information in this article applies to:

  • Microsoft SQL Server version 4.2x

BUG# NT:  437 (4.2) 


When tempdb becomes full, any temporary tables that are created will not get dropped when the transaction finishes.


SQL Server does not release the temporary tables correctly when tempdb is full.


Restart the SQL Server; this will clean up the temporary tables.


This problem was corrected in version 6.0.

Additional query words: temp db Windows NT

Keywords : kbprogramming
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2

Last Reviewed: January 28, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.