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.
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 name||Data type||Description|
|Action||nvarchar(10)||Type of action to be taken when synchronization occurs.|
DEL = delete
UPD = update
|Tranid||nvarchar(70)||Transaction ID that the command was executed under.|
|table column1...n||The value for each column of the table specified in tablename.|
|msrepl_tran_version||uniqueidentifier||This 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.