System Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Functions
  4. How to assign a user to a server role
The syntax  for sp_AddSrvRoleMember
sp_AddSrvRoleMember [@loginame = ] 'login_ID',
                    [@rolename = ] 'server_role_name'