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