FIX: Index Scans on Frequently Modified Table May Return Incorrect Results (312578)

SYMPTOMS

Under rare conditions where connections concurrently modify and read data on a particular page, a query that performs a range scan on the page may return rows that do not qualify for the specified range. The end result is that a query may return extra rows that should not qualify for the query.

This problem may affect the distribution agents in transactional replication. When the Distribution Agent receives unexpected rows while querying the MSrepl_commands table it causes an access violation (AV) exception in Distrib.exe that shuts down the agent. The following text may appear in the ReplExceptDist.log:

Microsoft SQL Server Replication: Exception Stack Dump
...
An exception was caught
in DISTRIB.EXE

* Exception Address = 7801166c
* Exception Code = c0000005
*
*******************************************************
Module Name Return Address Location
MSVCRT 00403a45 wcsncpy + 14
distrib 0040104c 00403a45
distrib 77e97d08 0040104c
KERNEL32 00000000

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

Hotfix

NOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 2. The English version of this fix should have the following file attributes or later:

   Version      File name        Description
   ------------------------------------------------

   8.00.468     Sqlservr.exe     SP1-based hotfix