Microsoft KB Archive/138718

{|
 * width="100%"|

FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

 * }

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 : kbprogramming kbusage

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600