Home > Archive > MS SQL Server Replication > September 2005 > Conflict Resolution









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Conflict Resolution
Anthony Small

2005-09-28, 7:24 am

Is it possible to have a message or notification if/when conflicts occur?
Is this art of any standard resolver or does this require a custom resolver
to be created?

TIA

Tony S.


Paul Ibison

2005-09-28, 7:24 am

Tony,
you could use a custom resolver or regularly poll the conflict table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


Anthony Small

2005-09-28, 9:23 am

Thanks Paul

Tony S.

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%23dijkUCxFHA.2212@TK2MSFTNGP15.phx.gbl...
> Tony,
> you could use a custom resolver or regularly poll the conflict table.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>



Panos

2005-09-30, 9:23 am

Hi Paul,
Is there only one conflict table or one conflict table per db table ?

Is the conflict table stored in the SQLCE db or only at the SQL2000 DB ?

Thank you for your time
Panayotis

Paul Ibison wrote:
> Tony,
> you could use a custom resolver or regularly poll the conflict table.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>


Paul Ibison

2005-09-30, 11:23 am

Panos,
there'll be one per table in the format:
conflict_<PublicationName>_<ArticleName>_usertablename
These tables are stored at the publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com