SysAdmin – Can perform any activity

ServerAdmin – Can change server configuration, restart, shutdown server

SecurityAdmin – Can manage server level logins, also can manage db level if they have permission on db

Granted: ALTER ANY LOGIN

ProcessAdmin – Can kill a process on an INSTANCE

Granted: ALTER ANY CONNECTION, ALTER SERVER STATE

DiskAdmin – Can manage the disk files

Granted: ALTER RESOURCES

BulkAdmin – Can perform BULK INSERT

Granted: ADMINISTER BULK OPERATIONS

SetupAdmin – Can add and REMOVE linked servers

Granted: ALTER ANY LINKED SERVER

Dbcreator – Can create, alter, DROP and restore any database on the instance

Granted: CREATE ANY DATABASE

Public – Default role for newly created login

sp_helpsrvrolemember : LIST out the members mapped with the server roles

SysAdmin – Can perform any activity

ServerAdmin – Can change server configuration, restart, shutdown server

SecurityAdmin – Can manage server level logins, also can manage db level if they have permission on db

Granted: ALTER ANY LOGIN

ProcessAdmin – Can kill a process on an instance

Granted: ALTER ANY CONNECTION, ALTER SERVER STATE

DiskAdmin – Can manage the disk files

Granted: ALTER RESOURCES

BulkAdmin – Can perform BULK INSERT

Granted: ADMINISTER BULK OPERATIONS

SetupAdmin – Can add and remove linked servers

Granted: ALTER ANY LINKED SERVER

Dbcreator – Can create, alter, drop and restore any database on the instance

Granted: CREATE ANY DATABASE

Public – Default role for newly created login

sp_helpsrvrolemember : List out the members mapped with the server roles