Which of the following members has access to SQL Server Agent ?
A. members of the systemadmin
B. members of the sysadmin
C. members of the sysadministraion
D. None of the mentioned
Answer:A
Which of the following members has access to SQL Server Agent ?
A. members of the systemadmin B. members of the sysadmin C. members of the sysadministraion D. None of the mentioned
Explanation:Members of the SQLAgentUserRole, SQLAgentReaderRole, and SQLAgentOperatorRole fixed database roles in msdb, and members of the sysadmin fixed server role have access to SQL Server Agent.