Post reply

Replication Error Messages

  • July 7, 2006 at 11:37 am

    #171516

    Can anyone tell me in what table the success/error messages for replication are stored? I am writing some monitor scripts that need to periodically check to see the outcome of several replication jobs and I was wondering where these messages are stored.

    Thanks!!!

  • July 7, 2006 at 4:05 pm

    #648093

    you can check the replication monitor status for the log reader and distribution agents history.

    ******************
    Dinakar Nethi
    Life is short. Enjoy it.
    ******************

  • July 11, 2006 at 6:08 am

    #648416

    Hi,

    You could start with this

    SELECT * FROM dbo.MSdistribution_history

    WHERE agent_id = (AGENT Number)

    ORDER BY Start_time

    Regards..Graeme

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply