Column Datatype Description
marker DATETIME A time valueindicating when the
latestmessages were applied.
Description When a consolidated database uses twoMessage Agents, one to populate the
stablequeue (-I) and one to receive and send messages (-r -s), the single
rowof the sr_marker table is used to ensure that messages received and
appliedto the database are sent before the Message Agent closes down.
sr_object tableFunction Holdsa list of SQL Remote objects. Theextraction utility needs to know not
toextract the SQL Remote system objects. Thesp_populate_sql_anywhere
procedurethat creates a set of Adaptive Server Anywhere system tables in
TEMPDBgets a list of SQL Remote objects from the sr_object table.
Columns
Column Datatype Description
name VARCHAR(128) Thename of the object.
type CHAR(1) Oneof the following:
♦UUser-definedtable
♦VView
♦PProcedure
sr_option tableFunction Eachrow describes a replication option used by SQL Remote.
Columns
Column Datatype Description
option VARCHAR(128) Thename of the option.
value VARCHAR(128) Thesetting for the option.
Description ☞Forinformation about available options, see “SQL Remote options” on
page315.
sr_passthrough tableFunction Eachrow describes a passthrough operation being sent to a user or to
340