sp_getqueuedrows (Transact-SQL)


Applies To: SQL Server

Retrieves rows at the Subscriber that have updates pending in the queue. This stored procedure is executed at the Subscriber on the subscription database.

Topic link icon Transact-SQL Syntax Conventions

sp_getqueuedrows [ @tablename = ] 'tablename'  
    [ , [ @owner = ] 'owner'  
    [ , [ @tranid = ] 'transaction_id' ]  

[ @tablename =] 'tablename'
Is the name of the table. tablename is sysname, with no default. The table must be a part of a queued subscription.

[ @owner =] 'owner'
Is the subscription owner. owner is sysname, with a default of NULL.

[ @tranid = ] 'transaction_id'
Allows the output to be filtered by the transaction ID. transaction_id is nvarchar(70), with a default of NULL. If specified, the transaction ID associated with the queued command is displayed. If NULL, all the commands in the queue are displayed.

0 (success) or 1 (failure)

Shows all rows that currently have at least one queued transaction for the subscribed table.

Column nameData typeDescription
Actionnvarchar(10)Type of action to be taken when synchronization occurs.

INS= insert

DEL = delete

UPD = update
Tranidnvarchar(70)Transaction ID that the command was executed under.
table column1...nThe value for each column of the table specified in tablename.
msrepl_tran_versionuniqueidentifierThis column is used for tracking changes to replicated data and to perform conflict detection at the Publisher. This column is added to the table automatically.

sp_getqueuedrows is used at Subscribers participating in queued updating.

sp_getqueuedrows finds rows of a given table on a subscription database that have participated in a queued update, yet currently have not been resolved by the queue reader agent.

sp_getqueuedrows requires SELECT permissions on the table specified in tablename.

Updatable Subscriptions for Transactional Replication
Queued Updating Conflict Detection and Resolution
System Stored Procedures (Transact-SQL)

Community Additions