ID Number: Q66872
1.10 1.11 4.20
OS/2
Summary
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 reference words: Transact-SQL