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

The information in this article applies to:

Microsoft SQL Server 7.0

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.

Modification Type:	Major	Last Reviewed:	3/14/2006
Keywords:	kbBug kbfix kbQFE KB258082