sp_helpmergearticle

Returns information about an article. This stored procedure is executed at the Publisher on the publication database.

Syntax

sp_helpmergearticle [ [ @publication = ] 'publication' ]
[ , [ @article = ] 'article' ]

Arguments

[@publication = ] 'publication'

Is the name of the publication about which to retrieve information. publication is sysname, with a default of %, which returns information about all merge articles contained in all publications in the current database.

[@article = ] 'article'

Is the name of the article for which to return information. article is sysname, with a default of %, which returns information about all merge articles in the given publication.

Result Set

Column name	Data type	Description
name	sysname	Name of the article.
source_object_owner	sysname	Name of the owner of the source object.
source_object	sysname	Name of the source object from which to add the article.
sync_object_owner	sysname	Name of the owner of the synchronization object.
sync_object	sysname	Name of the custom object used to establish the initial data for the partition.
description	nvarchar(255)	Description of the article.
status	tinyint	Status of the article.
creation_script	nvarchar(127)	Optional precreation script for the article.
conflict_table	nvarchar(258)	Name of the table storing the insert or update conflicts.
pre_creation_command	tinyint	Precreation method.
schema_option	binary(8)	Bitmap of the schema generation option for the article.
type	tinyint	Type of article.
column_tracking	int	Setting for column-level tracking.
article_resolver	nvarchar(255)	Custom resolver for the article.
subset_filterclause	nvarchar(2000)	WHERE clause specifying the horizontal filtering.
resolver_info	sysname	Name of the article resolver.
destination_object	sysname	Name of the destination object. Applicable to merge stored procedures, views, and UDF schema articles only.

Remarks

sp_helpmergearticle is used in merge replication.

Permissions