MSreplication_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. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru