merge replication - what data on the publisher refers to a specific subscriber?

• jjradha

  SSChasing Mays

  Points: 616

  More actions

  February 25, 2013 at 6:04 am

  #268978

  Hi fellow DBAs,

  Talking about merge replication, sql server 2005 sp2 standard edition.

  I am doing some research on this,

  but does anyone know how I can identify which data in the publisher goes into each of the subscribers?

  For example:

  Use myReplicatedDB

  go

  sp_spaceused 'dbo.MemberOrganisationLink'

  -- 1218931 rows on the publisher

  -- 875 rows on subscriber server500

  -- 1926 rows on subscriber server423

  -- 5380 rows on subscriber server871

  How can I go to the publisher and get the 875 rows that are on subscriber server500?

  I know I have a table AdminOffice, that has an AdminOfficeID field.

  Subscriber server500 has AdminOfficeId = 500

  Where can I go to see its “filters”?

  Thanks and regards

  Marcelo