Microsoft KB Archive/105032

{|
 * width="100%"|

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