• SQL Server 2005.

    Transactional (standard).

    Distribution Server set up on another machine.

    As straight forward a publication as you could imagine. Single table, no row filters, no column filters.

    I'm fairly new to replication, and in doing all of the set up through the wizards, I haven't deviated from the default settings at all.

    Every time I subscribe to a publication, these 2 extra sps get created.

    One of my collegues noticed that when you set distribution to run locally, these 2 sps are not created... I wonder what that has to do with it...

    Andy, do you not get these when sp's when you set up trans rep in 2005?