How to query or check the type of replication RRS feed

  • Question

  • I have servers with different type of replication setting.

    How to query or check the type of replication especially for  Bi-direction replication, p2p  replication and merge   ?

    Thanks in advance for any helps.

    Tuesday, August 27, 2019 10:24 AM

All replies

  • this is a start.
    select publisher_db, case 
    when publication_type=1 then 'snapshot' 
    when publication_type=0 then 'transactional'
    when publication_type=2 then 'merge' end , sync_method,
    case when allow_queued_tran  =0 then 'normal' else 'updateable subscriptions' end from MSpublications

    Tuesday, August 27, 2019 12:21 PM
  • Hi sqlman2011,


    Run the following query on the distribution database:


    SELECT      P.Publication     ,P.Publication_type     ,S.Subscriber_ID     ,S.Update_Mode FROM MSPublications P INNER JOIN MSSubscriptions S     ON P.Publication_ID = S.Publication_ID


    Publication_type - 0=Transactional, 1=Snapshot, 2=Merge


    Update_mode - 0=Read only, 1=Immediate update, 2=queued update with message queue, 3=Immediate update with queued update as failover using message queue, 4=Queued update with SQL Server queue, 5=Immediate update with queued update as failover using SQL Server queue


    Best regards,

    Dedmon Dai

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Wednesday, August 28, 2019 7:50 AM