| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MSreplication_queue (Transact-SQL) |
MSreplication_queue (Transact-SQL) |
VanMSFT |
vanto |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server]
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. |
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)