MSDN forum: rows in system table syssubscriptions in Publisher

Gao Peng 21 Reputation points
2022-12-27T09:22:19.157+00:00

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.
12,693 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-12-28T06:24:08.903+00:00

    Hi @Gao Peng ,

    Please refer to this document: https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/syssubscriptions-transact-sql?view=sql-server-ver16
    This article contains explanations of all the fields, which can help you understand.

    Best regards,
    Seeya

    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.

    0 comments