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.
OOps! You are currently offline.