Transact-SQL Reference
MSsubscription_articles
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 name | Data type | Description |
|---|---|---|
| agent_id | int | ID of the agent that services this article |
| artid | int | Article ID from the sysarticles table. |
| article | sysname | Name of the article from the sysarticles table. |
| dest_table | sysname | Name of the destination table from the sysarticles table. |
| owner | sysname | Owner of the subscription. |
| cft_table | sysname | Name of the conflict table for this article, for queued updating replication type. |
| columns | binary(32) | Bitmap of the replicated columns of the publication table from the sysarticles table. |