I setup push transactional replication from production database to a datacenter (hostsite).
The publisher and local distributor are running sql 2000 sp3.
The subscriber is running sql 2005 sp2.
When initial snapshoot completed with no error, I got an error with Violation of PRIMARY KEY constraint 'aaaaat_EnergyDataDaily_PK'. Cannot insert duplicate key in object 'dbo.t_EnergyDataDaily'. (Source: MSSQLServer, Error number : 2627).
How and waht is the workaround to solve this errors.?