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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » merge replication - what data on the...

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

Rate Topic

Display Mode

Topic Options

Author

Message

marcelo miorelli

Posted Monday, February 25, 2013 6:04 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:28 AM
Points: 14, Visits: 176

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 »

Permissions