title
MSrepl_transactions (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/04/2017
ms.prod
sql
ms.prod_service
database-engine
ms.reviewer
ms.technology
replication
ms.topic
language-reference
f1_keywords
MSrepl_transactions_TSQL
MSrepl_transactions
dev_langs
helpviewer_keywords
MSrepl_transactions system table
ms.assetid
d325288d-47ae-4488-8799-122f7ab43459
author
stevestein
ms.author
sstein
MSrepl_transactions (Transact-SQL) [!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md ]
The MSrepl_transactions table contains one row for each replicated transaction. This table is stored in the distribution database.
Column name
Data type
Description
publisher_database_id int The ID of the Publisher database.
xact_id varbinary(16) The ID of the transaction.
xact_seqno varbinary(16) The sequence number of the transaction.
entry_time datetime The time the transaction entered the distribution database.
Replication Tables (Transact-SQL) Replication Views (Transact-SQL)