Hi,

I have the following issue :
my replication is txn , immediate updating

This is an existing replication and i am changing one of the acct ABC123's
details via the Application.
From the Replication i could see that it says "1 transaction with 3 command
were delivered"
However, when i check the table of the destination database there's no change

where could i check for the error ?
is there any tables in the distribution table that i could check or i shld be
checking at the subscription database ?

kindly advise

tks & rdgs

--
Message posted via SQLMonster.com

maxzsim wrote on Fri, 28 Apr 2006 10:42:58 GMT:

[quoted text, click to view]

I'd look at the subscriber side to see if something is causing the row
changes to be rolled back - have you added a trigger to the table in the
subscriber?

Dan

Hi,

I have checked the MSrepl_transactions table after i changed the details
again and i could see a new record in that table.

during replication where would this record go to in the destination database ?


tks & rdgs

[quoted text, click to view]

--
Message posted via SQLMonster.com

Hi Dan ,

There's no trigger at the subscriber's end actually .

which MSrepl_XX table in the subscriber will get these changes ?

tks & rdgs


[quoted text, click to view]

--

Hi ,

Further info is from MSrepl_error there no record for this database


tks & rdgs

[quoted text, click to view]

--