Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSrepl_transactions (Transact-SQL)
Collapse the table of content
Expand the table of content

MSrepl_transactions (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft