We had set up merge replication with multiple publishers and a single subscriber. The articles are four tables (similar across all four publications).
The problem is that 1 of the tables has been synchronised from all publishers, but the rest 3 tables could not be.
We've tried enabling verbose logging, but to little effect. Here's the last log being entered before the operation fails:
Bulk copying data into table 'TABLE_NAME' failed.
The process could not bulk copy into table 'TABLE_NAME'
Possible settings that might be of interest:
Article Settings - Action if name is in use : Keep existing object unchanged
Synchronisation Direction : Download only to subscriber - Allow subscriber to make changes
Copy Primary Key Constraints : False
Copy Foreign Key Constraints : False
Copy Check Constraints : False
Copy Unique Constraints : True
Any help would be greatly appreciated.