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.
`conn_id`	`int`	Connection ID.
`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, conn_id)