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