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. |
