.png)
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.
Transact-SQL Syntax Conventions
- [ @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.
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. |
Reference
System Stored Procedures (Transact-SQL)Other Resources
Updatable Subscriptions for Transactional ReplicationQueued Updating Conflict Detection and Resolution
