Post reply

script to return the replication status

  • March 26, 2015 at 1:26 am

    #306161

    I need a script that will return the replication status as small int. Can someone help me with it?

  • March 26, 2015 at 7:54 am

    #1786554

    select p.publication,

    status = cast(m.status as smallint)

    from MSpublications p join MSreplication_monitordata m

    on p.publication_id = m.publication_id

    where agent_type = 3 -- distribution agent

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

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