Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

MSrepl_commands (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft