![](/images/backgrounds/253075/bg1c2.png)
Purpose Tostop a user from being able to receive SQL Remote messages from this
database.
Syntax sp_revoke_remoteuser_name
Argument Description
user_name
The user ID who will no longer be able to receive
SQLRemote messages.
Seealso “sp_grant_remoteprocedure” on page 393
Description The sp_revoke_remoteprocedure removes a user ID from the list of users
receivingmessages from the current database.
Example ♦Thefollowing statement revokes remote permissions from user Field
User:
sp_revoke_remote ’Field user’
go
432