SQLServerCentral / SQL Server 2005 / SS2K5 Replication / merge replication - what data on the publisher refers to a specific subscriber? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 02:26:56 GMT20merge replication - what data on the publisher refers to a specific subscriber?http://www.sqlservercentral.com/Forums/Topic1423585-291-1.aspxHi 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 myReplicatedDBgosp_spaceused 'dbo.MemberOrganisationLink'-- 1218931 rows on the publisher-- 875 rows on subscriber server500-- 1926 rows on subscriber server423-- 5380 rows on subscriber server871How 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 = 500Where can I go to see its “filters”?Thanks and regardsMarceloMon, 25 Feb 2013 06:04:12 GMTmarcelo miorelli