Export (0) Print
Expand All

sys.dm_repl_traninfo

Returns information on each replicated transaction.

Column name Data type Description

fp2p_pub_exists

tinyint

If the transaction is in a database published using peer-to-peer transactional replication.

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.

Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_traninfo.

Information is only returned for replicated database objects that are currently loaded in the replication article cache.

Community Additions

ADD
Show:
© 2014 Microsoft