View server roles and permissions per Login
SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other principals. Server-level roles are server-wide in their permissions scope. (Roles are like groups in the Windows operating system.) server_principals: Contains a row for every server-level principal. Other Useful Query Returns a description of the built in …
