Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

sp_replqueuemonitor

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Lists the queue messages from a SQL Server queue or Message Queuing for queued updating subscriptions to a specified publication. This stored procedure is executed at the Subscriber on the subscription database.

Syntax

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

Arguments

[ @publisher = ] 'publisher'

Is the name of the Publisher. publisher is sysname, with a default of NULL. The server must be configured for publishing. NULL for all Publishers.

[ @publisherdb = ] 'publisher_db' ]

Is the name of the publication database. publisher_db is sysname, with a default of NULL. NULL for all publication databases.

[ @publication = ] 'publication' ]

Is the name of the publication. publication is sysname, with a default of NULL. NULL for all publications.

[ @tranid = ] 'tranid' ]

Is the transaction ID. tranid is sysname, with a default of NULL. NULL for all transactions.

[ @queuetype = ] 'queuetype' ]

Is the type of queue that stores transactions. queuetype is tinyint with a default of 0, and can be one of these values.

Value Description
0 All types of queues
1 Message Queuing
2 SQL Server queue

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_replqueuemonitor is used in snapshot replication or transactional replication with queued updating subscriptions. The queue messages that do not contain SQL commands or are part of a spanning SQL command are not displayed.

Permissions

Only members of the sysadmin fixed server role or db_owner fixed database role can execute sp_addmergesubscription.

See Also

System Stored Procedures

Queued Updating Components

Queued Updating

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.