MSrepl_transactions (Transact-SQL)

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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance