rs_lastcommit

Replication Server uses the information in the rs_lastcommit table to find the last transaction committed from each data source.

The rs_lastcommit table is stored in each user database, not in the RSSD.

Column

Datatype

Description

origin

int

ID number for the primary database a row represents.

origin_qid

binary

Identifies the last committed transaction in the stable queue for the origin database.

secondary_qid

binary

If a subscription materialization queue exists for the origin database, this column contains the last transaction in that queue that has been committed in the replicate database.

origin_time

datetime

Time at origin for the transaction.

dest_commit_time

datetime

Time the transaction was committed at the destination.

pad1

binary(255)

Filler to pad the row so only one row fits on a database page.

pad2

binary(255)

Filler to pad the row so only one row fits on a database page.

pad3

binary(255)

Filler to pad the row so only one row fits on a database page.

pad4

binary(255)

Filler to pad the row so only one row fits on a database page.

pad5

binary(255)

Filler to pad the row so only one row fits on a database page.

pad6

binary(255)

Filler to pad the row so only one row fits on a database page.

pad7

binary(255)

Filler to pad the row so only one row fits on a database page.

pad8

binary(83)

Filler to pad the row so only one row fits on a database page.

Indexes

Unique clustered index on (origin)