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)