Home Forums SQL Server 2005 SS2K5 Replication Need to replicate multiple databases (publications) to one central subscriber RE: Need to replicate multiple databases (publications) to one central subscriber

  • Certainly - make sure all you repl stored procedures are in subscriber db. If lost you can recreate by executing the following on publisher, then take output and exec on subscriber: exec sp_scriptpublicationcustomprocs @publication = 'PubNameHere'

    Also - good idea to initially set distribution agent profile to 'continue on data consistency errors..' - you will need to perform manual sync to make sure subscriber in sync w/ publisher.

    Good luck.

    ChrisB MCDBA

    MSSQLConsulting.com

    Chris Becker bcsdata.net