Query to show what articles are being replicated

  • I know how to use the GUI to see what is being replicated but How do I QUERY the Database to show what articles (tables) are being replicated????

  • You could try the sysarticles table in the published database or in the distribution database on your distributor you could run something like:

    selectss.srvname,

    p.publication,

    a.publisher_db,

    a.article

    frommspublicationsp

    inner join

    msarticlesa

    ona.publisher_id= p.publisher_id

    anda.publication_id= p.publication_id

    anda.publisher_db= p.publisher_db

    inner join

    master.dbo.sysserversss

    onss.srvid= p.publisher_id

    order by ss.srvname,p.publication,a.publisher_db,a.article

  • Thank you!!!

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

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