sp_getqueuedrows (Transact-SQL)
Retrieves rows at the Subscriber that have updates pending in the queue. This stored procedure is executed at the Subscriber on the subscription database.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_getqueuedrows [ @tablename = ] 'tablename'
[ , [ @owner = ] 'owner'
[ , [ @tranid = ] 'transaction_id' ]
Arguments
- [ @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.
Return Code Values
0 (success) or 1 (failure)
Result Sets
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. INS= insert 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. |
Remarks
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.
Permissions
sp_getqueuedrows requires SELECT permissions on the table specified in tablename.
See Also
Reference
System Stored Procedures (Transact-SQL)
Other Resources
Updatable Subscriptions for Transactional Replication
Queued Updating Conflict Detection and Resolution