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
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.