I don't have any experience of replication, but was trying what I thought was a simple test to see how well it works. After sorting out various things, I got the data to the subscriber, but the replication process always wants to write to tables owned by dbo - which is not the owner of the table I want the data to end up in.
My publication table is called "something.units" - which it selects data from ok and passes to the subscriber ok. But the subscriber code omits the owner name and so the table it wants to use is "dbo.units". I can't see where this is set, can anyone help?