I have a table called Table1 at both pulisher and subcriber which is related
to
many other tables. If i modify a row at the subcriber then instead of
updating the row at pulisher..merge agent detects conflict and overwrites the
row at the subcriber with the row that publisher has and newly inserted row
at subscriber is added to conflict table with the errortype =9 and text
The row was updated at subcriberX but could not be updated at PublisherX.
Unable to synchronize the row because the row was updated by a different
process outside of replication.
I am using SQL Server 2000 with SP4
ThanksI believe this error is cause by a non-logged operation - like DTS. Did you
DTS some data into one of the tables you are merge replicating?
--
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
"kailux4" <kailux4@.discussions.microsoft.com> wrote in message
news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
>I have a table called Table1 at both pulisher and subcriber which is
>related
> to
> many other tables. If i modify a row at the subcriber then instead of
> updating the row at pulisher..merge agent detects conflict and overwrites
> the
> row at the subcriber with the row that publisher has and newly inserted
> row
> at subscriber is added to conflict table with the errortype =9 and text
> The row was updated at subcriberX but could not be updated at PublisherX.
> Unable to synchronize the row because the row was updated by a different
> process outside of replication.
> I am using SQL Server 2000 with SP4
> Thanks|||Hello Hilary,
I am not using DTS or other non logged operations..but still i get this error
"Hilary Cotter" wrote:
> I believe this error is cause by a non-logged operation - like DTS. Did you
> DTS some data into one of the tables you are merge replicating?
> --
> 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
> "kailux4" <kailux4@.discussions.microsoft.com> wrote in message
> news:2C08C5E7-EC46-4110-8027-51AB8EF2C290@.microsoft.com...
> >I have a table called Table1 at both pulisher and subcriber which is
> >related
> > to
> > many other tables. If i modify a row at the subcriber then instead of
> > updating the row at pulisher..merge agent detects conflict and overwrites
> > the
> > row at the subcriber with the row that publisher has and newly inserted
> > row
> > at subscriber is added to conflict table with the errortype =9 and text
> >
> > The row was updated at subcriberX but could not be updated at PublisherX.
> > Unable to synchronize the row because the row was updated by a different
> > process outside of replication.
> > I am using SQL Server 2000 with SP4
> >
> > Thanks
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment