Merge Conflict Data

hi all,
i observed some conflicts in conflict viewer.i am able to see the data in
conflict tables.my question is i included one userid column in each table to
identify the data from where it is inserted or updated.now in conflict table
i am getting only publisher side userid i am not getting the subscriber side
userid.
your help is appreciated.
thanks
reddy
What process is filling in the user id that does the modification? If you
are using a default and have your publisher configured to have the higher
priority, the publisher's id will "win".
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"reddy" <reddy@.discussions.microsoft.com> wrote in message
news:2A7B22B8-3FC6-4C41-8371-F2C3A9CF25BE@.microsoft.com...
> hi all,
> i observed some conflicts in conflict viewer.i am able to see the data in
> conflict tables.my question is i included one userid column in each table
to
> identify the data from where it is inserted or updated.now in conflict
table
> i am getting only publisher side userid i am not getting the subscriber
side
> userid.
> your help is appreciated.
> thanks
> reddy

Merge Application Conflict Log

Is it possible to write conflict sql in some persistent table.
I know that they a writen in merge replication tables and can be viewed via
conflict viewer
but they a lost after the snapshot run.
I need to keep them forever.
Probably i can write custom resolver who will do thta - but is there any
'out of the box' solution?
Grigoris - as far as I know there isn't any out-of-the-box solution but
perhaps the easiest solution would be to regularly poll the conflict table
and to write the values into an audit table.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Use perfmon to watch the conflicts per second counter of SQL
Server:Replication Merge and run a job which reads the conflict tables when
conflicts occur.
You can also use sp_helpmergearticleconflicts and run it on the publisher
and subscriber. It will return a list of articles with conflicts and you can
then manually or programmatically retrieve them.
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
"Grigoris Tsolakidis" <gcholakidis@.spam_remove.hotmail.com> wrote in message
news:%237acphUZHHA.588@.TK2MSFTNGP06.phx.gbl...
> Is it possible to write conflict sql in some persistent table.
> I know that they a writen in merge replication tables and can be viewed
> via conflict viewer
> but they a lost after the snapshot run.
> I need to keep them forever.
> Probably i can write custom resolver who will do thta - but is there any
> 'out of the box' solution?
>