## FIX: Temporary Tables Not Dropped When Tempdb Is Full

Q105032

The information in this article applies to:

- Microsoft SQL Server version 4.2x

    BUG# NT:  437 (4.2)

## SYMPTOMS

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

## CAUSE

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

## WORKAROUND

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

## STATUS

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.