(1) sp_browsereplcmds will show you the command in human-readable format
(2) The above command will indicate which table on the subscriber is
affected.
(3) The agent history will report any errors. You can also enable logging to
a text file (http://support.microsoft.com/?id=312292).

Please also check that the distribution agent is ether running continuously
or running on a schedule that is appropriate.

Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

tk you for ur advice

[quoted text, click to view]

--
Message posted via SQLMonster.com

Hi ,

This is with regards to an earlier posting which i am still not able to
resolve.

Basically replication is on-going and working fine but certain updates were
somehow not replication across.

mine is a transactional replication.

i have checked the followings :

From Distributor/Publisher :
1) i could see that it says "1 transaction with 3 command were delivered"
2) I have checked the MSrepl_transactions table after i changed the details
again and i could see a new record in that table.
3) There's no trigger at both end on the table
4) From MSrepl_error there no record related to this database

Questions :
1) The record in MSrepl_transactions are in binary , how can i see the
"actual" data ?
2) The record from distributor/publisher has to go to certain table in the
destination db , but which is it ?
3) Is there a log somewhere becuase the SQL Server Logs dun seem to log such
errors

appreciate ur kind advise so i can resolve this issue as it been causing me
some problems

tks & rdgs

--