Replication-Quick way to determine the articles

  • Comments posted to this topic are about the item Replication-Quick way to determine the articles

  • No results from both of my production replication servers, one SQL 2005 one SQL 2012.

  • -----------------------------------------------
    --marcello miorelli
    --adding the schema to the articles
    -----------------------------------------------
    SELECT art.artid,
    table_name = OBJECT_SCHEMA_NAME(art.OBJID) + N'.' + OBJECT_NAME(art.OBJID),
    dest_table_name = art.dest_owner + N'.' + art.dest_table,
    sync_table_name = OBJECT_SCHEMA_NAME(art.sync_objid) + N'.' + OBJECT_NAME(art.sync_objid),

    art.[del_cmd],
    art.[upd_cmd],
    art.[ins_cmd],
    art.[filter],
    art.[filter_clause],
    art.fire_triggers_on_snapshot,
    art.[schema_option]

    FROM syspublications pub
    INNER JOIN sysarticles art
    ON art.pubid = pub.pubid

    • This reply was modified 5 months, 1 week ago by  jjradha.
    • This reply was modified 5 months, 1 week ago by  jjradha. Reason: struggling with the formatting

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

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