MS SQL Server Replication - Can subscriber know the results of Merge rep?

Author

Can subscriber know the results of Merge rep?

SteveInBeloit

2005-09-23, 8:24 pm

We have two notebooks doing Merge replication (PULL) from the distributor.
We use the Active-X merge from ACCESS.

Can the subscriber know the results of the replication? I now go to EM on
the publisher and look at the Merge Agents to see if there were conflicts,
then to the conflict viewer. Is there a way I can know from the subscriber
doing the Pull?

Thanks,
Steve

Hilary Cotter

2005-09-24, 11:23 am

Use the status event.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

"SteveInBeloit" < SteveInBeloit@discus
sions.microsoft.com> wrote in message
news:7A88B570-396C-4FB6-BE96- 12F60CD99AE6@microso
ft.com...
> We have two notebooks doing Merge replication (PULL) from the distributor.
> We use the Active-X merge from ACCESS.
>
> Can the subscriber know the results of the replication? I now go to EM on
> the publisher and look at the Merge Agents to see if there were conflicts,
> then to the conflict viewer. Is there a way I can know from the
> subscriber
> doing the Pull?
>
> Thanks,
> Steve

SteveInBeloit

2005-09-26, 11:23 am

Hi,
I am having trouble making it work in VBA behind ACCESS. In VB, looks like
you would use:

Private WithEvents mobjMerge As SQLMERGXLib.SQLMerge

in VBA, it would bd

DIM mobjMerge As SQLMERGXLib.SQLMerge.

I cannot get the WithEvents in anywhere where it will pass the compiler.

any thoughts.

"Hilary Cotter" wrote:

> Use the status event.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "SteveInBeloit" < SteveInBeloit@discus
sions.microsoft.com> wrote in message
> news:7A88B570-396C-4FB6-BE96- 12F60CD99AE6@microso
ft.com...
>
>
>

Sponsored Links