MS SQL Server Replication - View synchronization content

Author

View synchronization content

Christian Hamel

2005-09-28, 11:24 am

Hello all,
We're using both Transactional & Merge replication between our main SQL
Server 2KSP4 Enterprise and Sales Rep running MSDE on their laptop. I'm
currently investigating some problem (Not related to the replication itself)
and would like to know if there is a way to see what was the data content
that has been replicated at a specific date/time?
We have developped an home made software that the user goes in the look
and enter data and there's an approval process with their managers and I
would like to confirm that some user are not going directly into the
database to change some values. I doubt it but just want to make sure. Any
helps would be greatly appreciated. Thanks.

Paul Ibison

2005-09-29, 3:24 am

Christian,
there's a possibility to see what's in the metadata tables waiting to get
processed, both in transactional and merge, but no capability to see the
(replication) origin of rows after replication. You could perhaps add
another column at the subscriber with a default to hold this info, and then
update the update stored procedure in transactional replication to keep it
in sync (inserts would take care of themselves). deletes would be another
issue entirely and you could edit the delete stored proc to log these to an
audit table which also holds the datatime. Anyway, you get the picture that
there's nothing out of the box for this.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Sponsored Links