Article ID: 153954
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q153954
SYMPTOMS
A stored procedure that performs the following actions:
- creates a temporary table
- inserts data into the table
- creates a cursor for read-only access that is then used to update the contents of the temporary table
- drops the cursor
- drops the temporary table
can, if executed by multiple users, result in the Checkpoint Process being chosen as a deadlock victim (spid 3). In this case, the following message will come up three times:
The message will be followed by the following errors:
A thread-level Access Violation will also be displayed.
If you run sp_who prior to receiving 1105 errors in tempdb, the Checkpoint Process is not present, and if the client processes continue to run, the result is that tempdb eventually fills because the log is not being truncated.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem was corrected in the latest Microsoft SQL Server U.S. Service Pack. For information on obtaining the Service Pack, query on the following word in the Microsoft Knowledge Base (without the spaces):
S E R V P A C K
Additional query words: sp1
Keywords: kbfix kbnetwork KB153954