Get-ReplTransPendingCommandInfo

Calls the TransPendingCommandInfo method for all subscriptions.

Syntax

Get-ReplTransPendingCommandInfo [-pubMon] <PublicationMonitor> [<CommonParameters>]

Detailed Description

The Get-ReplTransPendingCommandInfo function calls the TransPendingCommandInfo method for all subscriptions.

Related Commands

* Get-ReplTransPendingCommandInfo
* Get-ReplPublicationMonitor

Parameters

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

Input Type

Microsoft.SqlServer.Replication.PublicationMonitor You can pipe PublicationMonitor objects to Get-ReplTransPendingCommandInfo

Return Values

Microsoft.SqlServer.Replication.PendingCommandInfo Get-ReplPublicationMonitor returns Microsoft.SqlServer.Replication.PendingCommandInfo object

Notes

Equivalent to executing sp_replmonitorsubscriptionpendingcmds. Only available for Microsoft SQL Server version 2005 or later.

Examples

EXAMPLE 1

Get-ReplPublicationMonitor "Z002\sql2K8" | Get-ReplTransPendingCommandInfo
This command calls the TransPendingCommandInfo method for SQL Server Z002\SQL2K8.