Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

merge replication - what data on the publisher refers to a specific subscriber? Expand / Collapse
Posted Monday, February 25, 2013 6:04 AM


Group: General Forum Members
Last Login: Wednesday, October 28, 2015 11:39 AM
Points: 17, Visits: 360
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
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
Post #1423585
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse