sp_remote procedure
Purpose This procedure is used by the SQL Remote Message Agent, and should not
becalled directly, with a single exception described below. It manages rows
inthe sr_remoteuser table.
Syntax sp_remote operation,
user_name
[, offset ]
[, confirm ]
Argument Description
operation
Thename of an action. Theonly value that should be
used by a user is reset; all others are for use by the
MessageAgent.
user_name
Thename of the remote user being reset
offset
Notused
confirm
Notused
Description This procedure is used by the SQL Remote Message Agent, and should not
becalled directly with the single exception of the reset call. It maintains the
messagetracking information in the sr_remoteuser table.
Thefollowing special case can be used directly, when creating a custom
databaseextraction process:
sp_remote reset, remote_user
where

remote_user

isthe remote user name.
Thiscommand starts all subscriptions for a remote user in a single
transaction. It sets the log_sent and confirm_sent values in sr_remoteuser
tableto the current position in the transaction log. It also sets the created and
startedvalues in sr_subscription to the current position in the transaction
logfor all subscriptions for this remote user. The procedure does not do a
commit. Youmust do an explicit commit after this call.
Inorder to write an extraction process that is safe on a live database, the data
mustbe extracted at isolation level 3 in the same transaction as the
subscriptionsare started.
424