Microsoft KB Archive/256017

From BetaArchive Wiki
Knowledge Base

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

Article ID: 256017

Article Last Modified on 10/17/2003


  • Microsoft SQL Server 6.5 Standard Edition

This article was previously published under Q256017

BUG #: 18859 (SQLBUG_65)


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.


To work around this behavior, use either of the following:

  • Use US Regional settings.


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


Microsoft has confirmed this to be a problem in SQL Server 6.5.

Keywords: kbbug kbpending KB256017