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 |