sp_helpmergearticle

Transact-SQL Reference

Transact-SQL Reference

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

Execute permissions default to the public role.

See Also

sp_addmergearticle

sp_changemergearticle

sp_dropmergearticle

System Stored Procedures