MSsubscription_articles (Transact-SQL)


Applies To: SQL Server

The MSsubscription_articles table contains information regarding the articles in a queued subscription. This table is populated only for the replication types of queued updating and immediate updating with queued updating as a failover.

Column nameData typeDescription
agent_idintThe ID of the agent that services this article
artidintThe article ID from the sysarticles table.
articlesysnameThe name of the article from the sysarticles table.
dest_tablesysnameThe name of the destination table from the sysarticles table.
ownersysnameThe owner of the subscription.
cft_tablesysnameThe name of the conflict table for this article, for queued updating replication type.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions