I have already set up the replication system - replication definition and
subscription are ready, rep agent and DSI start without any error. However ,
the rep agent seems cant get any message from the primary database and the
pimary database can receive data from other primary database. What's wrong
with rep agent.
Have you enabled replication using sp_setreptable? It gets me all the time, you setup everything and wonder why it isn't replicating. I have a reminder on my laptop that pops up every hour when I'm doing an engagement that says. "Have you done sp_setreptable or sp_reptostandby?"