PRB: Error 7129 If Concurrent Processes Update Same Text Page (66872)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbother KB66872 |
|---|
|