MSsubscription_articles (Transact-SQL)
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 |
The ID of the agent that services this article |
artid |
int |
The article ID from the sysarticles table. |
article |
sysname |
The name of the article from the sysarticles table. |
dest_table |
sysname |
The name of the destination table from the sysarticles table. |
owner |
sysname |
The owner of the subscription. |
cft_table |
sysname |
The name of the conflict table for this article, for queued updating replication type. |
See Also
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables