Re: Turn OFF Automated Conflict Resolver in Merge Replication

Tech-Archive recommends: Fix windows errors by optimizing your registry

So the interactive resolver is working for you in SQL 2005 or SQL 2000?

--
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



"Aubrey" <miscuates@xxxxxxxxxxxxx> wrote in message
news:9D18D9F3-E17B-415E-8297-2B59A0A7EC7A@xxxxxxxxxxxxxxxx
Yes; It DID Reinitialize Subscribers. Minimum work - check one box! Other
than the 3.5 hr DSL VPN snapshot download, it was smooth! Those who
travelled
to the main office did it in 7-8 minutes over the LAN.

It is a joy to use the Conflict Resolver, again! Most Conflicts have been
Splits -- some Winner's records need to use some of the Losers cell info.
At
least now I get DBA type information with which to focus custom resolver
programming! Let the affected User chose.
--
Aubrey Kelley


"Hilary Cotter" wrote:

This is disabled in SQL 2005. In SQL 2000 Right click on your
publication,
select the articles tab, and select article properties, and select the
resolver tab and ensure that the interactive resolved is checked.

Then in WSM. Click properties, and click the other tab, and select
resolve
conflicts interactively.

You will probably have to reinitialize your subscribers and possibly drop
them before making this change.

--
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



"Aubrey" <miscuates@xxxxxxxxxxxxx> wrote in message
news:525E00D9-3641-4C2D-9AC3-FFDAAD8EC2B9@xxxxxxxxxxxxxxxx
How do we change from Automatic to Interactive Conflict Resolution in
an
Anonymous Merge Replication scenario? The Subscriptions are created
locally
with Windows Synchronizer, which has that choice in the Properties
(real
joy,
as that must be done by an Administrator). How do we change Enterprise
Manager, Replication, Publication Properties?

Users are very upset, and the business negatively affected, because the
defaults are wiping out newly created account information.

Back in the (MDB) dark ages, we had to do all conflict resolution with
the
Windows Synchronizer Conflict Resolver. Its downside was the delay
between
data entry and DBA attention.
--
Aubrey Kelley





.

Relevant Pages

  • Re: Turn OFF Automated Conflict Resolver in Merge Replication
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... It is a joy to use the Conflict Resolver, ...
    (microsoft.public.sqlserver.replication)
  • Re: conflict viewer error in sync manager
    ... The way the interactive resolver is ... A dialog is generated telling you there was a conflict and to contact your ... > Microsoft SQLServer Stored Procedure Resolver ... > Microsoft SQL Server Averaging Conflict Resolver ...
    (microsoft.public.sqlserver.replication)
  • Re: Updates gone after merge
    ... Hilary Cotter ... > Cascading updates and deletes are off. ... In the conflict resolver, the conflict shows the field that has ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication - Inventory Conflct Resolver
    ... Conflict resolver is used to resolve conflicts. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Updates gone after merge
    ... I don't believe it is a reserved keyword in SQL Server. ... Hilary Cotter ... > the conflict starts to occur after the second update/replication. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)