"krygim" <krygim@hotmail.com> wrote in message
news:OAZEcl2hEHA.3348@TK2MSFTNGP12.phx.gbl...
> I created a 2PC transaction replication on a simple database for testing.
> Changes in the publisher are successfully replicated to the subscriber.
> However, when changes are made to the subscriber, the following error
> message is shown:
>
>
>
> "Another user has modified the contents of this table or view; the
database
> row you are modifying no longer exists in the database."
>
>
>
> Could somebody help to solve the problem?
>
>
>
> Thanks in advance!
>
>
>
> KM
>
>

"Krygim" <krygim@hotmail.com> wrote in message
news:u24De94hEHA.3476@tk2msftngp13.phx.gbl...
> Hi Paul,
>
> There are only 3 rows in my table. The PK values in the subscriber and
> publisher are exactly the same. The PK column of both the subscriber and
the
> publisher are marked as Identity (Not For Replication). I got the same
> message even if I add a new row in the subscriber.
>
> In the Query Analyzer on the publishing database, I tried the
> sp_browsereplcmds and got the message:
> "Could not find stored procedure 'sp_browsereplcmds'."
>
> KM
>
>
> "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> news:em3ZXU3hEHA.4064@TK2MSFTNGP12.phx.gbl...
> > KM,
> > can you do a search on hte publisher for the PK value of the row you are
> > changing. Presumably it is not there and sp_browsereplcmds on the
> > distributor should reveal a relevant delete statement.
> > HTH,
> > Paul Ibison
> >
> >
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:em3ZXU3hEHA.4064@TK2MSFTNGP12.phx.gbl...
> KM,
> can you do a search on hte publisher for the PK value of the row you are
> changing. Presumably it is not there and sp_browsereplcmds on the
> distributor should reveal a relevant delete statement.
> HTH,
> Paul Ibison
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:%23XSgUZ3hEHA.244@TK2MSFTNGP10.phx.gbl...
> where are you seeing this message? DataGrid?
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "krygim" <krygim@hotmail.com> wrote in message
> news:OAZEcl2hEHA.3348@TK2MSFTNGP12.phx.gbl...
> > I created a 2PC transaction replication on a simple database for
testing.
> > Changes in the publisher are successfully replicated to the subscriber.
> > However, when changes are made to the subscriber, the following error
> > message is shown:
> >
> >
> >
> > "Another user has modified the contents of this table or view; the
> database
> > row you are modifying no longer exists in the database."
> >
> >
> >
> > Could somebody help to solve the problem?
> >
> >
> >
> > Thanks in advance!
> >
> >
> >
> > KM
> >
> >
>
>

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:uCyeWO6hEHA.3548@TK2MSFTNGP09.phx.gbl...
> try running this command in the distributor.
>
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
>
> "Krygim" <krygim@hotmail.com> wrote in message
> news:u24De94hEHA.3476@tk2msftngp13.phx.gbl...
> > Hi Paul,
> >
> > There are only 3 rows in my table. The PK values in the subscriber and
> > publisher are exactly the same. The PK column of both the subscriber and
> the
> > publisher are marked as Identity (Not For Replication). I got the same
> > message even if I add a new row in the subscriber.
> >
> > In the Query Analyzer on the publishing database, I tried the
> > sp_browsereplcmds and got the message:
> > "Could not find stored procedure 'sp_browsereplcmds'."
> >
> > KM
> >
> >
> > "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> > news:em3ZXU3hEHA.4064@TK2MSFTNGP12.phx.gbl...
> > > KM,
> > > can you do a search on hte publisher for the PK value of the row you
are
> > > changing. Presumably it is not there and sp_browsereplcmds on the
> > > distributor should reveal a relevant delete statement.
> > > HTH,
> > > Paul Ibison
> > >
> > >
> >
> >
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%23qrm%23XCiEHA.592@TK2MSFTNGP11.phx.gbl...
> KM,
> I wasn't very precise but by distributor I meant distribution database on
> the distributor - the sp should be there. Please post back after running
it
> to tell us if the rows you refer to are have been modified on the
publisher.
> TIA,
> Paul Ibison
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:Ov3S0PFiEHA.2788@TK2MSFTNGP10.phx.gbl...
> Krygim,
> everything you've done looks correct, but I've never heard of this before.
> Can you run this:
> sp_browsereplcmds
> go
> select db_name()
> (just to check that you are in the correct database). If it returns
> 'distribution' then perhaps a service-pack install didn't succeed and you
> could check sqlsp.log file from the c:\windows directory to see if this is
> the case.
> HTH,
> Paul Ibison
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:ug0zd6FiEHA.1656@TK2MSFTNGP09.phx.gbl...
> KM,
> it looks like something has gone wrong. The script instdist.sql creates
the
> distribution database and creates the procedure you now need, but somehow
it
> hasn't completely run. You could disable publishing and restart (sorry:))
or
> you could get the procedure creation script from the file mentioned above
> (install directory) and run it manually, hoping that something else isn't
> missing.
> HTH,
> Paul Ibison
>
>