SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To reset all SQL Remote information for all remote users.
sp_subscription_reset
This procedure resets all the entries in the sr_remote_user and sr_subscrioption tables to zero or NULL.