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 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

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