TABLE 1: Fixed Server Roles
ROLE PRIVILEGES
sysadmin Can perform any activity in SQL Server
serveradmin Can set serverwide configuration options, shut down the server
setupadmin Can manage linked servers and startup procedures
securityadmin Can manage logins and CREATE DATABASE permissions, also read error logs
processadmin Can manage processes running in SQL Server
dbcreator Can create and alter databases
diskadmin Can manage disk files