Get-ReplArticle

Gets an Article.

Syntax

Get-ReplArticle [-pub] <Object> [<CommonParameters>]

Detailed Description

The Get-ReplArticle function gets the Articles from the specified Publication. Equivalent to executing sp_helpmergepublication or sp_helparticle.

Related Commands

* Get-ReplArticle
* Get-ReplPublication

Parameters

Name Description Required? Pipeline Input Default Value
pub    true  true (ByValue)   

Input Type

Microsoft.SqlServer.Replication.Publication You can pipe Publication objects to Get-ReplArticle

Return Values

Microsoft.SqlServer.Replication.TransArticle or Microsoft.SqlServer.Replication.MergeArticle Depending on the publication type Get-ReplArticle returns either a Microsoft.SqlServer.Replication.TransArticle or Microsoft.SqlServer.Replication.MergeArticle object

Examples

EXAMPLE 1

Get-ReplPublication "Z002\sql2K8" | Get-ReplArticle
This command gets the Articles for all publications on SQL Server Z002\SQL2K8.