Which SQL Server fixed server role has the highest level of administrative privileges?

Options

  • A. serveradmin
  • B. sysadmin
  • C. securityadmin
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

B. sysadmin

Detailed Explanation

  • sysadmin: Has unrestricted administrative privileges over the SQL Server instance.
  • Members can perform any activity on the server.
  • It is a fixed server role, not a fixed database role.