found replication column

  • I found a column in a table called 'msrepl_tran_version' . But I'm not aware of any replication on the table or the DB.

    What can I check to see what kind of replication is being used?

  • That column is added by replication when it does not have a unique identifier in a table.

    Hopefully this will get you started. Run it in the context of the Database you are investigating. You will get an error if there is no replication.

    select distinct p.name as Publication

    , p.description

    , a.name as Article

    , a.dest_table as [Destination Table]

    , s.srvname as [Subscriber]

    ,s.dest_db as [Target DB]

    from syspublications p

    inner join sysarticles a on a.pubid = p.pubid

    inner join syssubscriptions s on s.artid = a.artid

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

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