User's Manual

Column Data type Description
marker DATETIME A time value indicating when the
latest messages were applied.
Description When a consolidated database uses two Message Agents, one to populate the
stable queue (-I) and one to receive and send messages (-r -s), the single
row of the sr_marker table is used to ensure that messages received and
applied to the database are sent before the Message Agent closes down.
sr_object table
Function Holds a list of SQL Remote objects. The extraction utility needs to know not
to extract the SQL Remote system objects. The sp_populate_sql_anywhere
procedure that creates a set of Adaptive Server Anywhere system tables in
TEMPDB gets a list of SQL Remote objects from the sr_object table.
Columns
Column Data type Description
name VARCHAR(128) The name of the object.
type CHAR(1) One of the following:
♦ U User-defined table
♦ V View
♦ P Procedure
sr_option table
Function Each row describes a replication option used by SQL Remote.
Columns
Column Data type Description
option VARCHAR(128) The name of the option.
value VARCHAR(128) The setting for the option.
Description ☞ For information about available options, see “SQL Remote options” on
page 315.
sr_passthrough table
Function Each row describes a passthrough operation being sent to a user or to
340