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.