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

  • From what I saw it looks like Microsoft updated all supported versions of SQL server at the same time, so the real secret was just getting to either a service pack that was released after the change was made or to a cumulative update that was created after the change was made. I believe I saw a couple occurrences where you could have stayed at a lower service pack and picked up the most recent cumulative update if necessary (as long as the service pack was still supported) or probably simply installed the correct hot fix.