BUG: Temporary Tables Not Dropped When Tempdb Is Full

ID: Q105032

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x


BUG# OS/2: 1764 (4.2)
       NT:  437 (4.2)

SYMPTOMS

When tempdb becomes full, any temporary tables 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

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: temp db Windows NT


Keywords          : kbprg kbbug4.20 SSrvServer SSrvWinNT 
Version           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 17, 1999