Returns information about an article.
sp_helpmergearticle [[@publication =] 'publication'] [,[@article =] 'article']
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 |
sp_helpmergearticle is used in merge replication.
Execute permissions default to the public role.
sp_addmergearticle | sp_dropmergearticle |
sp_changemergearticle | System Stored Procedures |