MSrepl_commands (Transact-SQL)
The MSrepl_commands table contains rows of replicated commands. This table is stored in the distribution database.
| Column name | Data type | Description |
|---|---|---|
publisher_database_id |
int |
The ID of the Publisher database. |
xact_seqno |
varbinary(16) |
The transaction sequence number. |
type |
int |
The command type. |
article_id |
int |
The ID of the article. |
originator_id |
int |
The ID of the originator. |
command_id |
int |
The ID of the command. |
partial_command |
bit |
Indicates whether this is a partial command or not. |
command |
varbinary(1024) |
The command value. |
hashkey |
int |
Internal-use only. |
originator_lsn |
varbinary(16) |
Identifies the LSN for the command in the originating publication. This is used in peer-to-peer transactional replication. |
See Also
Reference
Replication Views (Transact-SQL)
sp_replcmds (Transact-SQL)
Concepts
Replication Tables (Transact-SQL)
Other Resources
How Transactional Replication Works