FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

Q138718

The information in this article applies to:

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 : kbprogramming kbusage
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600


Last Reviewed: March 25, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.