Wednesday, March 21, 2012

How to tell what was deleted during synch

Warren,
have a look at my script here:
http://www.replicationanswers.com/Merge.asp
This gives the ability to see pending changes. Once the
merge agent has run, the records have been deleted, so by
then it's too late, unless you want to use LogExplorer.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thanks Paul, much appreciated.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:039301c53503$4d549510$a401280a@.phx.gbl...
> Warren,
> have a look at my script here:
> http://www.replicationanswers.com/Merge.asp
> This gives the ability to see pending changes. Once the
> merge agent has run, the records have been deleted, so by
> then it's too late, unless you want to use LogExplorer.
> HTH,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

No comments:

Post a Comment