Incompatability problem replicating between SQL 2000 SP3 and SP4?

• Tom Brehony

  SSC-Addicted

  Points: 454

  More actions

  December 12, 2005 at 5:48 am

  #92687

  Have any of you experienced problems replicating between SQL 2000 servers on SP3 and SP4?

  Is this a problem/bug/feature with SP3/4 or is it something inherent in the design of replication?

  Anyone found a work around for this?

  Tom.

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  December 13, 2005 at 6:26 am

  #609184

  Past experience has shown that incompatible sps can lead to problems.

  I'd suggest you don't mix service packs this way. It certainly gave me problems on clusters. ( nodes not all at same sp level )

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/