fp2p_pub_exists

tinyint

If the transaction is in a database published using peer-to-peer transactional replication. If true, the value is 1; otherwise, it is 0.

db_ver

int

Database version.

comp_range_address

varbinary(8)

Defines a partial rollback range that must be skipped.

textinfo_address

varbinary(8)

In-memory address of the cached text information structure.

fsinfo_address

varbinary(8)

In-memory address of the cached filestream information structure.

begin_lsn

nvarchar(64)

Log sequence number (LSN) of the beginning log record for the transaction.

commit_lsn

nvarchar(64)

LSN of commit log record for the transaction.

dbid

smallint

Database ID.

rows

int

ID of the replicated command within the transaction.

xdesid

nvarchar(64)

Transaction ID.

artcache_table_address

varbinary(8)

In-memory address of the cached article table structure last used for this transaction.

server

nvarchar(514)

Server name.

server_len_in_bytes

smallint

Character length, in bytes, of the server name.

database

nvarchar(514)

Database name.

db_len_in_bytes

smallint

Character length, in bytes, of the database name.

originator

nvarchar(514)

Name of the server where the transaction originated.

originator_len_in_bytes

smallint

Character length, in bytes, of the server where the transaction originated.

orig_db

nvarchar(514)

Name of the database where the transaction originated.

orig_db_len_in_bytes

smallint

Character length, in bytes, of the database where the transaction originated.

cmds_in_tran

int

Number of replicated commands in the current transaction, which is used to determine when a logical transaction should be committed.

is_boundedupdate_singleton

tinyint

Specifies whether a unique column update affects only a single row.

begin_update_lsn

nvarchar(64)

LSN used in a unique column update.

delete_lsn

nvarchar(64)

LSN to delete as part of an update.

last_end_lsn

nvarchar(64)

Last LSN in a logical transaction.

fcomplete

tinyint

Specifies whether the command is a partial update.

fcompensated

tinyint

Specifies whether the transaction is involved in a partial rollback.

fprocessingtext

tinyint

Specifies whether the transaction includes a binary large data type column.

max_cmds_in_tran

int

Maximum number of commands in a logical transaction, as specified by the Log Reader Agent.

begin_time

datetime

Time the transaction began.

commit_time

datetime

Time the transaction was committed.

session_id

int

ID of the change data capture log scan session. This column maps to the session_id column in sys.dm_cdc_logscan_sessions.

session_phase

int

Number that indicates the phase the session was in at the time the error occurred. This column maps to the phase_number column in sys.dm_cdc_errors.

is_known_cdc_tran

bit

Indicates the transaction is tracked by change data capture.

0 = Transaction replication transaction.

1 = Change data capture transaction.

error_count

int

Number of errors encountered.