Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayMSreplication_queue (Transact-SQL)
Applies to: 
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)