Microsoft KB Archive/258082

= FIX: Abort of Command That Uses a Worktable May Result in Orphaned Extents in the Tempdb System Database =

Article ID: 258082

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q258082



BUG #: 57373 (SQLBUG_70)



SYMPTOMS
Aborting a command that has an open worktable may result in extents that are marked allocated in the Global Allocation Map (GAM) but that are not in use by any object. An example of this might be canceling the execution of a stored procedure that contains a static TSQL cursor.



WORKAROUND
Reduce or remove the source for the aborts of the commands that require worktables.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.



MORE INFORMATION
One of the common causes for an abort would be an application sending an attention event to the server when canceling a query.

Over time, the orphaned extents can cause the tempdb system database to fill up or grow, which might lead to unexpected 1105 errors in the tempdb system database.

Keywords: kbbug kbfix kbqfe KB258082

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.