sys.sp_replqueuemonitor

Description

Lists the queue messages from a SQL Server queue or Microsoft Message Queuing for queued updating subscriptions to a specified publication. If SQL Server queues are used, this stored procedure is executed at the Subscriber on the subscription database. If Message Queuing is used, this stored procedure is executed at the Distributor on the distribution database. is used to get all Publishers.

Syntax

sp_replqueuemonitor
[ [ @publisher = ]
N
'publisher'
]
[ , [ @publisherdb = ]
N
'publisherdb'
]
[ , [ @publication = ]
N
'publication'
]
[ , [ @tranid = ]
N
'tranid'
]
[ , [ @queuetype = ] queuetype ]
[ ; ]