Ok, we have a really strange issue here.
We have a database on a SQL 2000 box that has a table called InOutStatus this table is transactional replicated to another SQL 2000 box. In this table there is a field called "EditDateTime" that has a default value of GETDATE() so it records the system datetime that a change was made. On the front end server it is recording the correct datetime for all employees, but when it replicates there is one employee that it is changing the datetime to a specific datetime.
In other words, if I look at the replicated data, the datetime is correct for all employees, but this one employee (data is below), basically the third column should have the same datetime as the second column.
Gone 5/31/06 4:51 pm 05/31/2006 3:31:43 PM
In 5/31/06 3:34 pm 05/31/2006 3:31:43 PM
In 6/1/06 8:10 am 05/31/2006 3:31:43 PM
Lunch 6/1/06 12:14 pm 05/31/2006 3:31:43 PM
In 6/1/06 1:25 pm 05/31/2006 3:31:43 PM
Gone 6/1/06 5:22 pm 05/31/2006 3:31:43 PM
In 6/2/06 8:21 am 05/31/2006 3:31:43 PM
Lunch 5/26/06 12:02 pm 05/26/2006 11:03:24 AM
In 5/26/06 1:05 pm 05/26/2006 11:03:24 AM
Gone 5/26/06 4:32 pm 05/26/2006 11:03:24 AM
In 5/30/06 8:16 am 05/26/2006 11:03:24 AM
Lunch 5/30/06 12:02 pm 05/26/2006 11:03:24 AM
In 5/30/06 1:03 pm 05/26/2006 11:03:24 AM
Gone 5/30/06 4:44 pm 05/26/2006 11:03:24 AM
In 5/31/06 8:02 am 05/26/2006 11:03:24 AM
Lunch 5/31/06 12:09 pm 05/26/2006 11:03:24 AM
In 5/31/06 1:09 pm 05/26/2006 11:03:24 AM
In 5/25/06 10:21 am 05/25/2006 10:06:08 AM
Lunch 5/25/06 12:03 pm 05/25/2006 10:06:08 AM
In 5/25/06 1:00 pm 05/25/2006 10:06:08 AM
Gone 5/25/06 4:58 pm 05/25/2006 10:06:08 AM
In 5/26/06 8:08 am 05/25/2006 10:06:08 AM
Gone 5/22/06 5:02 pm 05/22/2006 3:23:47 PM
In 5/23/06 8:24 am 05/22/2006 3:23:47 PM
Lunch 5/23/06 11:48 am 05/22/2006 3:23:47 PM
In 5/23/06 12:48 pm 05/22/2006 3:23:47 PM
Gone 5/23/06 4:56 pm 05/22/2006 3:23:47 PM
In 5/24/06 8:19 am 05/22/2006 3:23:47 PM
Lunch 5/24/06 12:03 pm 05/22/2006 3:23:47 PM
In 5/24/06 1:04 pm 05/22/2006 3:23:47 PM
Gone 5/24/06 5:03 pm 05/22/2006 3:23:47 PM
In 5/25/06 8:01 am 05/22/2006 3:23:47 PM
In 5/22/06 12:57 pm 05/22/2006 9:37:08 AM
Lunch 5/22/06 11:56 am 05/22/2006 9:37:08 AM
In 5/19/06 8:26 am 05/19/2006 8:26:59 AM
Lunch 5/19/06 12:02 pm 05/19/2006 8:26:59 AM
In 5/19/06 1:02 pm 05/19/2006 8:26:59 AM
Gone 5/19/06 4:33 pm 05/19/2006 8:26:59 AM
In 5/22/06 8:20 am 05/19/2006 8:26:59 AM
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination alone are omnipotent. -Calvin Coolidge
We have a database on a SQL 2000 box that has a table called InOutStatus this table is transactional replicated to another SQL 2000 box. In this table there is a field called "EditDateTime" that has a default value of GETDATE() so it records the system datetime that a change was made. On the front end server it is recording the correct datetime for all employees, but when it replicates there is one employee that it is changing the datetime to a specific datetime.
In other words, if I look at the replicated data, the datetime is correct for all employees, but this one employee (data is below), basically the third column should have the same datetime as the second column.
Gone 5/31/06 4:51 pm 05/31/2006 3:31:43 PM
In 5/31/06 3:34 pm 05/31/2006 3:31:43 PM
In 6/1/06 8:10 am 05/31/2006 3:31:43 PM
Lunch 6/1/06 12:14 pm 05/31/2006 3:31:43 PM
In 6/1/06 1:25 pm 05/31/2006 3:31:43 PM
Gone 6/1/06 5:22 pm 05/31/2006 3:31:43 PM
In 6/2/06 8:21 am 05/31/2006 3:31:43 PM
Lunch 5/26/06 12:02 pm 05/26/2006 11:03:24 AM
In 5/26/06 1:05 pm 05/26/2006 11:03:24 AM
Gone 5/26/06 4:32 pm 05/26/2006 11:03:24 AM
In 5/30/06 8:16 am 05/26/2006 11:03:24 AM
Lunch 5/30/06 12:02 pm 05/26/2006 11:03:24 AM
In 5/30/06 1:03 pm 05/26/2006 11:03:24 AM
Gone 5/30/06 4:44 pm 05/26/2006 11:03:24 AM
In 5/31/06 8:02 am 05/26/2006 11:03:24 AM
Lunch 5/31/06 12:09 pm 05/26/2006 11:03:24 AM
In 5/31/06 1:09 pm 05/26/2006 11:03:24 AM
In 5/25/06 10:21 am 05/25/2006 10:06:08 AM
Lunch 5/25/06 12:03 pm 05/25/2006 10:06:08 AM
In 5/25/06 1:00 pm 05/25/2006 10:06:08 AM
Gone 5/25/06 4:58 pm 05/25/2006 10:06:08 AM
In 5/26/06 8:08 am 05/25/2006 10:06:08 AM
Gone 5/22/06 5:02 pm 05/22/2006 3:23:47 PM
In 5/23/06 8:24 am 05/22/2006 3:23:47 PM
Lunch 5/23/06 11:48 am 05/22/2006 3:23:47 PM
In 5/23/06 12:48 pm 05/22/2006 3:23:47 PM
Gone 5/23/06 4:56 pm 05/22/2006 3:23:47 PM
In 5/24/06 8:19 am 05/22/2006 3:23:47 PM
Lunch 5/24/06 12:03 pm 05/22/2006 3:23:47 PM
In 5/24/06 1:04 pm 05/22/2006 3:23:47 PM
Gone 5/24/06 5:03 pm 05/22/2006 3:23:47 PM
In 5/25/06 8:01 am 05/22/2006 3:23:47 PM
In 5/22/06 12:57 pm 05/22/2006 9:37:08 AM
Lunch 5/22/06 11:56 am 05/22/2006 9:37:08 AM
In 5/19/06 8:26 am 05/19/2006 8:26:59 AM
Lunch 5/19/06 12:02 pm 05/19/2006 8:26:59 AM
In 5/19/06 1:02 pm 05/19/2006 8:26:59 AM
Gone 5/19/06 4:33 pm 05/19/2006 8:26:59 AM
In 5/22/06 8:20 am 05/19/2006 8:26:59 AM
Persistence....Nothing in the world can take the place of persistence. Talent will not; nothing is more common than unsuccessful men with talent. Genius will not; unrewarded genius is almost a proverb. Education will not; the world is full of educated derelicts. Persistence and determination alone are omnipotent. -Calvin Coolidge
