SQL Server/SQL Server CE Merge Replication Ambiguous Column Name E - 01-27-2006 , 07:46 AM
We are running sql server 2000 sp3 with handheld devices SQL Server CE 2.0.
Data is being transferred from SQL CE to SQL Server via IIS 6.0.
I added a new column using the publication wizard in enterprise manager.
I then ran an agent shapshot from the the sql server; this worked okay.
After adding the new column ('Remarks) to the article we get a conflict on
merge replication initiated from the handheld SQL CE device.
The error I am receiving is below:
The row was inserted at 'np013571 - -28297750' but could not be inserted at
'npsqlserver1\npsqlserver.OperationD'. Ambiguous column name 'Remarks'.
Any idea why we are receiving this error?