Problem with date
in [Replication]
|
Prev: Reintilize replication via a T-SQL script or command
Next: Replication - automatic identity range support
From: Benoit Dufort Benoit on 24 Mar 2010 09:27 Hi, I try to use the peer-to-peer replication, I follow the step in "Configure Peer-to-Peer Transactional Replication" http://msdn.microsoft.com/en-us/library/ms152536.aspx. Some table synchonize well, but sometimes I have a problem with the datetime format. The table has a field of type datetime, and if I look at the stored proc used to synchronize the data on the publisher, the format of the date was 'YYYY-MM-DD hh:mm:ss.fff' but the publisher received the format 'YYYY-MM-DD hh:mm:ss.fffffff', so the stored proc failed since the field is a datetime not a datetime2. How can I fixed this? Thanks.
From: Benoit Dufort on 25 Mar 2010 09:35
I found that the problem is not the date field is the order of the field of the query generated for the replication was not the same as the insert statement I do. The update statement for replication work, but not the insert. Any idea? "Benoit Dufort" wrote: > Hi, > > I try to use the peer-to-peer replication, I follow the step in "Configure > Peer-to-Peer Transactional Replication" > http://msdn.microsoft.com/en-us/library/ms152536.aspx. > > Some table synchonize well, but sometimes I have a problem with the datetime > format. > > The table has a field of type datetime, and if I look at the stored proc > used to synchronize the data on the publisher, the format of the date was > 'YYYY-MM-DD hh:mm:ss.fff' but the publisher received the format 'YYYY-MM-DD > hh:mm:ss.fffffff', so the stored proc failed since the field is a datetime > not a datetime2. > > How can I fixed this? > > Thanks. |