Validation differences between EM and QA

• FreeHansje

  SSChampion

  Points: 11751

  More actions

  May 26, 2004 at 8:09 am

  #82906

  Hi there,

  I've setup the following:

  Create DBNAme..TableA on serverA, create DBNAme..TableA on ServerB. I make ServerA A publisher and Distributor for DBNAme..tableA for a Transactional replication. I add ServerB.DBNAme..TableA as subscriber. test the replicationprocess and it works fine. Now watch.

  I add a record to TableA at the SUBSCRIBER. Subscriber now has 9 records, Publisher has 8 records. I choose Validate from the Publicationproperties in Enterprise manager, and as expected some moments later I can read in the Distribution Agents History the message, that TableA might be out of sink: 8 records vs 9 records.

  Then I start the validationprocess with the help of sp_publication_validation. I do this on ServerA, the Publisher and subscriber. To my amazement I get the message Generated expected rowcount value of 8 for tableA

  Why is there a difference?

  Greetz,
  Hans Brouwer

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  May 27, 2004 at 9:21 am

  #508040

  Are you sure you execute both full counts in EM and QA? I mean actually executing a count operation instead ob getting in from sysindexes.