MSDN forum: rows in system table syssubscriptions in Publisher

Gao Peng 21 Reputation points

Backgroud, the replicated database has 7 publications (3 transactional + 4 merge). And all subscriptions are in mode of 'pull'

execute "Select * from syssubscriptions " in this replicated database, I found an interesting but confusing result. Each subscriber has 10 rows, which deviates from what I should have expected. I used to think it should be 11 rows (4*2 each merge replication has 2 rows in corresponding+ 3 for transactional)

Can anyone with rich experience in this area explain what is actually going on here for me?
Thanks in advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,087 questions
{count} votes

1 answer

Sort by: Oldest
  1. Seeya Xi-MSFT 15,111 Reputation points Microsoft Vendor

    Hi @Gao Peng ,

    Please refer to this document:
    This article contains explanations of all the fields, which can help you understand.

    Best regards,

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.