SQl 2005 Bidirectional Merge replication - Replication Monitor Stats Show Updates being Uploaded from Subscriber to Publish which I would like to Audit at a record Level Any Advice?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » SQl 2005 Bidirectional Merge replication -...

SQl 2005 Bidirectional Merge replication - Replication Monitor Stats Show Updates being Uploaded from Subscriber to Publish which I would like to Audit at a...

Rate Topic

Display Mode

Topic Options

Author

Message

mattmc

Posted Thursday, March 14, 2013 9:32 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 29, 2013 6:24 PM
Points: 16, Visits: 200

Hi all,

I am looking at the Update Stats in replication Monitor for Subscriber Changes Uploaded to Publisher and I was hoping that

I could audit those to see at a record level which ones have been uploaded to the Publisher.

In general i am seeking to track through where the Updates are actually coming from as to my knoledge only Inserts are being made on the tables in question. After opening up profiler and tracing through whats actually going its looking like SQL Replication Process Itself is updating the records on the Subscriber which is then causing the record to be Uploaded to the Publisher if that makes sense as its looking like there is not other Data modification Statements occurring on the Subscriber Database apart from SQL replication itself.

Any advice appreciated.

Kind Regards,

MMck

Post #1431345

« Prev Topic | Next Topic »

Permissions