Explain the purpose of setupadmin in SQL Server.

Options
- Can manage linked servers and startup procedures.
- Can manage processes running in SQL Server.
- Can set server-wide configuration options, can shut down the server.
- All of above

CORRECT ANSWER : Can manage linked servers and startup procedures.

Discussion Board
setupadmin

The members of setupadmin server role can manage linked servers (add or remove linked servers), manage replication, manage extended stored
procedures, and execute some system stored procedures, such as sp_serveroption. The setupadmin role lets users manage linked servers and alter server startup procedures. Members of this role can also configure replication and install extended stored procedures.

Prajakta Pandit 03-7-2017 06:48 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲