sp_helparticle Replication Stored Procedure

Displays information about an article.

Syntax

sp_helparticle publication[, article] [, returnfilter]

where

publication

Is the name of the publication.

article

Is the name of an article in the publication. If article is not supplied, information on all articles for the specified publication is returned.

returnfilter

Specifies if the filter clause should be returned. Is 1 if the filter clause should be returned, 0 if not. The default is 1.

Remarks

Displays the article name, base table name, destination table, synchronization object, type, status, filter, description, insert command, update command, delete command, creation script path, and (depending on the returnfilter parameter) filter clause.

Example

This example returns information about the types_table article in the pub_alltypes publication. The filter clause will be returned.

sp_helparticle pub_alltypes, types_table

Permission

Execute permission defaults to the public group.

Table Used

sysobjects, syscolumns, sysusers, sysarticles, syspublications, syssubscriptions, sysservers

See Also