• To tell you the truth, I have never really bothered to discover how SQL Server works out that it is the distribution agent that is inserting data. I assume that the agent is calling system stored procs to do its stuff. If you really need to know, SQL Profiler will most likely give the info.

    As with any other INSERT/UPDATE/DELETE, all replication changes to the database are recorded in the transaction log.