MSreplication_queue (Transact-SQL)
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. |