MSreplication_queue (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The MSreplication_queue table is used by the replication process to store the queued commands issued by all the queued updating subscriptions that are using SQL-based queued. This table is stored in the subscription database.

Column name Data type Description
publisher sysname The name of the Publisher.
publisher_db sysname The name of the publication database.
publication sysname The name of the publication.
tranid sysname The transaction ID under which the queued command was executed.
data varbinary(8000) The packed bytestream that stored information about the queued command.
datalen int The length of data, in bytes.
commandtype int The type of command being queued:

1 = User command in transaction.

2 = Subscription synchronization command.
insertdate datetime The date of insertion.
orderkey bigint The identity column that increases monotonically.
cmdstate bit The command state:

0 = Complete.

1 = Partial.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)