Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

  New Information - SQL Server 2000 SP3.

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


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


[@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.


sp_helpmergearticle is used in merge replication.


Only members of the db_owner fixed database role, the replmonitor role in the distribution database, or the publication access list for the current publication can execute sp_helpmergearticle.

See Also




System Stored Procedures

© 2015 Microsoft