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