rs_locater

Stores the last locator field received by stable queues from each of their senders.

Column

Datatype

Description

sender

int

Sender site ID

type

char(1)

Who is using this row:

  • R – RSI (route)

  • D – distributor locater used for subscriptions

  • E – executor for Replication Agent

  • U – locator at last system upgrade

  • W – distributor locator used for a warm standby application

  • C – locater for the last successfully executed replication definition request sent by Replication Agent.

  • F – locater for failed command sent by Replication Agent.

  • S – locater for failed command that Replication Server skipped.

locater

binary(36)

Last queue ID received from this sender

Indexes

Unique clustered index on (sender, type)