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
Author
Message
Posted Monday, February 25, 2013 6:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 7:57 AM
Points: 16, Visits: 310
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
Post #1423585
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse