Distribution database table. Contains the actual transactions. There is one entry for every transaction that is stored in the distribution database.
| Column | Datatype | Description |
|---|---|---|
| publisher_id | smallint | The local server ID of the publishing server. |
| publisher_db | varchar(30) | The name of the published database. |
| job_id | int | The job ID. |
| type | tinyint | The transaction type: 0 SQL command 1 Noop command 2 SQL script 3 Native bcp command 4 Character bcp command 5 Manual sync |
| xactid_page | int | If the event is log based, the page of the transaction. |
| xactid_row | smallint | If the event is log based, the row of the transaction. |
| xactid_ts | binary(8) | The timestamp of the transaction. |
| entry_time | datetime | The time the row was added to the table. |
ucMSjobs clustered, unique on publisher_db, publisher_id, job_id
| sp_replcleanup |