title
MSrepl_commands (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/03/2017
ms.prod
sql
ms.prod_service
database-engine
ms.reviewer
ms.technology
replication
ms.topic
language-reference
f1_keywords
MSrepl_commands
MSrepl_commands_TSQL
dev_langs
helpviewer_keywords
MSrepl_commands system table
ms.assetid
53b9f9cd-9429-47a0-aba2-908fc60e7036
author
stevestein
ms.author
sstein
MSrepl_commands (Transact-SQL) [!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md ]
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.
Replication Tables (Transact-SQL) Replication Views (Transact-SQL) sp_replcmds (Transact-SQL)