Bienvenido al foro, esta es la instruccion:

sp_addrolemember [ @rolename = ] 'role',
[ @membername = ] 'security_account'

__________________
Share what you know, learn what you don't