BUG: Distribution Task May Fail With "Divide By Zero" Error (256017)


The information in this article applies to:

  • Microsoft SQL Server 6.5
This article was previously published under Q256017
BUG #: 18859 (SQLBUG_65)

SYMPTOMS

In transactional replication the distribution task may fail with this error:
Error : 14151, Severity: 20, State: 1 Replication-Distribution: Task 'Name_of_distribution_task' failed. 22012[Microsoft][ODBC SQL Server Driver][SQL Server]Divide by zero error encountered.

WORKAROUND

To work around this behavior, use either of the following:
  • Use US Regional settings.

    -or-
  • Use a Msvcrt40.dll file later than version 4.20.6172.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB256017
©2003 Microsoft Corporation. All rights reserved.