MSrepl_transactions (Transact-SQL)
SQL Server 2005
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. |
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System ViewsOther Resources
Integration Services TablesBackup and Restore Tables
Log Shipping Tables