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. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables
