Filter
Top Products
Column Description
type_id An identification number for the message type.
type_name The message type. There is a separate row for each
of the following:
♦ FILE
♦ MAPI
♦ VIM
♦ SMTP
publisher_address The publisher’s address for the message type type_-
name.
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 mes-
sages 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.
348