Microsoft KB Archive/66872

= PRB: Error 7129 If Concurrent Processes Update Same Text Page =

Article ID: 66872

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q66872



SYMPTOMS
When executing concurrent processes that are performing text type operations on the same table, one of the processes sometimes aborts with the following error message:

Msg 7129, Level 16, State 2:

Synchronization time stamp does not agree with text data page values.



CAUSE
This is expected behavior if the two processes are trying to update the same text page at the same time. Both processes select for a text pointer, one of the processes locks the text data page first and updates it. When the other process tries to update the text page, the timestamp is different and the second process is not allowed to update the text page. The process is then aborted with the error message listed above.

Additional query words: Transact-SQL Windows NT

Keywords: kbother KB66872

-

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

© Microsoft Corporation. All rights reserved.