FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

ID: Q138718

The information in this article applies to:

Microsoft SQL Server, version 6.0

BUG# NT: 11767 (6.00)

SYMPTOMS

The milliseconds portion of the datetime field does not get replicated. When sp_replcmds generates the inserted value for a datetime field, the milliseconds portion is not included.

WORKAROUND

Do not include milliseconds for a datetime field in any table that is going to be included in an article for replication.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 2 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 rep

Keywords          : kbprg kbusage SSrvRep kbbug6.00 kbfix6.00.sp2 
Version           : 6.0
Platform          : WINDOWS

Last Reviewed: May 3, 1997