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.

Permissions

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

Remarks

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

See Also

Reference

Dynamic Management Views and Functions
Replication Related Dynamic Management Views

Help and Information

Getting SQL Server 2005 Assistance