sys.sp_helparticle

Description

Displays information about an article. This stored procedure is executed at the Publisher on the publication database. For Oracle Publishers, this stored procedure is executed at the Distributor The name of an article in the publication. isn’t supplied, information on all articles for the specified publication is returned. Specifies whether the filter clause should be returned.

Syntax

sp_helparticle
[ @publication = ]
N
'publication'
[ , [ @article = ]
N
'article'
]
[ , [ @returnfilter = ] returnfilter ]
[ , [ @publisher = ]
N
'publisher'
]
[ , [ @found = ] found
OUTPUT
]
[ ; ]

Examples

Example 1

sp_helparticle

Example 2

DECLARE
@publication
AS sysname;
SET
@publication = N
'AdvWorksProductTran'
;
USE
[AdventureWorks2022]
EXEC sp_helparticle
@publication = @publication;
GO