Merge Agent/

If i want to inquire about the outstand transactions before i sync. what kind
of info can i pull out form the merge agent/or where to get this info..say i
want to know how many deletes did i do in this replica before i decide to
sync...
is that possible programatically?
You can't, but you could query the publisher and subscriber for the number
of transactions at the max generation. You would query the tombstone and
contents tables to get this number.
Hilary
"Lottoman2000 NEWBE" <Lottoman2000NEWBE@.discussions.microsoft.com> wrote in
message news:1047463C-6853-499F-A879-B40FC4E648E4@.microsoft.com...
> If i want to inquire about the outstand transactions before i sync. what
> kind
> of info can i pull out form the merge agent/or where to get this info..say
> i
> want to know how many deletes did i do in this replica before i decide to
> sync...
> is that possible programatically?
>
|||Have a look at the procedure spBrowseMergeChanges on this page:
http://www.replicationanswers.com/Merge.asp
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)