mssubscription-articles-transact-sql.md

title	MSsubscription_articles (Transact-SQL)
description	MSsubscription_articles (Transact-SQL)
author	VanMSFT
ms.author	vanto
ms.date	03/03/2017
ms.service	sql
ms.subservice	replication
ms.topic	reference
f1_keywords	MSsubscription_articles MSsubscription_articles_TSQL
helpviewer_keywords	MSsubscription_articles system table
dev_langs	TSQL

MSsubscription_articles (Transact-SQL)

[!INCLUDE 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 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

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