Use this statement to stop a user from being able to receive SQL Remote messages from this database.
REVOKE REMOTE FROM userid, ...
REMOTE permissions are required for a user ID to receive messages in a SQL Remote replication installation. The REVOKE REMOTE statement removes a user ID from the list of users receiving messages from the current database.
Must have DBA authority.
Automatic commit. Drops all subscriptions for the user.
SQL/2003 Vendor extension.
REVOKE REMOTE FROM SamS;