FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

ID: Q138718

The information in this article applies to:

Microsoft SQL Server version 6.0

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 : winnt:6.0
Platform : winnt
Issue type :