Contents Index sr_remotetypes view sr_subscriptions view

SQL Remote User's Guide
  System Objects for Adaptive Server Enterprise
    SQL Remote system views

sr_remoteusers view


Function 

Lists information about remote users and their status.

Columns 
Column Description
user_name The user ID of the user with REMOTE permissions.
consolidate The column contains either an N to indicate a user granted REMOTE permissions, or a Y to indicate a user granted CONSOLIDATE permissions.
type_name The name of the message system used to send messages to this user.
address The address to which SQL Remote messages are to be sent. The address must be appropriate for the address_type.
frequency How frequently SQL Remote messages are to be sent.
send_time The next time messages are to be sent to this user.
next_send The next time messages are to be sent to this user, in a more comprehensible format.
log_send Messages are sent only to subscribers for whom log_send is greater than log_sent.
time_sent The time the most recent message was sent to this subscriber.
log_sent The log offset for the most recently sent operation.
confirm_sent The log offset for the most recently confirmed operation from this subscriber.
send_count How many SQL Remote messages have been sent.
resend_count Counter to ensure messages are applied only once at the subscriber database.
time_received The time the most recent message was received from this subscriber.
log_received The log offset in the subscriber's database for the operation most recently received at the current database.
confirm_received The log offset in the subscriber's database for the most recent operation for which a confirmation message has been sent.
receive_count How many messages have been received.
rereceive_count Counter to ensure messages are applied only once at the current database.

Contents Index sr_remotetypes view sr_subscriptions view