MSrepl_commands (Transact-SQL)


Applies To: SQL Server

The MSrepl_commands table contains rows of replicated commands. This table is stored in the distribution database.

Column nameData typeDescription
publisher_database_idintThe ID of the Publisher database.
xact_seqnovarbinary(16)The transaction sequence number.
typeintThe command type.
article_idintThe ID of the article.
originator_idintThe ID of the originator.
command_idintThe ID of the command.
partial_commandbitIndicates whether this is a partial command or not.
commandvarbinary(1024)The command value.
hashkeyintInternal-use only.
originator_lsnvarbinary(16)Identifies the LSN for the command in the originating publication. This is used in peer-to-peer transactional replication.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
sp_replcmds (Transact-SQL)

Community Additions