||This role has ownership of SQL Server. This is similar to Domain Admins or the Administrator account in Windows.
||This role sets serverwide configuration options and can also shut down the server. This is similar to the Windows Power Users local group.
||There's no real counterpart in Windows to the following rolesexcept maybe using Group Policy Objects. This role can link to other SQL Servers and can change startup procedures for the server.
||This role creates logins and also has the CREATE DATABASE permission. It can also read error logs and manage passwords.
||You may find this role useful to assign to developers. It allows an account to manage SQL Server processes. It can save you a phone call.
||This role can create, alter, and drop databases.
||If you're managing a large database server, this role allows an account to manage the disk files.
||This role allows an account to insert large amounts of data into tables. You'll often see this role used in OPAL shops.