Home Forums SQL Server 2005 SS2K5 Replication recreating replication without reinitializing missing sp_MSsetupnosyncsubwithlsnatdist_helper RE: recreating replication without reinitializing missing sp_MSsetupnosyncsubwithlsnatdist_helper

  • Hi,

    I found the solution. It turns out that our publisher was running the most recent SP2 update for SQL 2008 R2 but the distributor and subscriber were only running 2008 R2 SP2. when I installed the cumulative update package the procedures were created in the master database and I was able to create the subscriptions.

    Thanks, and hopefully this helps if someone else runs into the same issue.