Home Forums SQL Server 2005 SS2K5 Replication SQL Server Replication with SS2K Publisher and SS2K5 Subscriber RE: SQL Server Replication with SS2K Publisher and SS2K5 Subscriber

  • I have never worked on this scenario ( 2K publisher and 2005 subscriber), but here is what i think about it:-

    1. Did you run the snapshot agent and apply the snapshot once ? ( ps: kinda obvious but just checking )

    If you have ensured that the snapshot was applied at the subscriber and still you dont see the SPs, then you can create a subscription on some test database in 2K server and then copy over the stored procs from there to your 2005 server.

    Hope that helped