Can someone give me an example and basic explanation of sp_repldone. BOL is
getting me down ;-)

--


Duncan

Duncan,
in many senses there is little one needs to know about sp_repldone. It is
used in transactional replication (by the distribution agent, not manually)
to mark the log as read to a particular point. This means the transactions
in the log relevant to a particular article have been read and transferred
(and by default modified to sp calls) to MSrepl_commands in the distribution
database. Once this has been done, if you are using simple recovery mode the
log will be truncated on the checkpoint or if full recovery mode the log can
be backed up/truncated. Sometimes people report problems with transaction
logs not being truncated, and it is a result of transactional replication
having been removed but only partially successfully. In this case you might
need to run sp_repldone yourself to clear it up, but this is the only case
where you'll need manual intervention.
HTH,
Paul Ibison