Anand Kavalapara 5.Mar.04 06:53 AM a Web browser LEI LEI - 3.2 Windows NT
We have a Timestamped one way replication from Lotus Notes to SQL Server.
The key fields are IDNumber, Licensee and CreatedDate.
Since createddate has a time component too, the SQL Server Column is of type Long Datetime.
Which is of the format mm/dd/yyyy hh:mm:ss:nnn
Where nnn gives 1000th of a sec. The problem is notes does not have a 1000th component of this sort and on and off we get duplicate entries in SQL server for the same entry in lotus Notes. The only variant being the one thousandth part of second of the CreatedDate field
We need to have the Time part of Date but not the thousandth part.