MSrepl_transactions (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

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