How to assign a user to a server role : sp_AddSrvRoleMember « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_AddSrvRoleMember
The syntax for sp_AddSrvRoleMember

sp_AddSrvRoleMember [@loginame = ] 'login_ID',
                    [@rolename = ] 'server_role_name'








25.21.sp_AddSrvRoleMember
25.21.1.How to assign a user to a server role
25.21.2.A statement that assigns a user to a server role