To view the roles defined in the current databaseThere are several points in the process of creating and using a database when you may need to find information about a Microsoft® SQL Server™ database role or a fixed server role. For example, you may need to see what roles exist in the current database, or list the fixed server roles.
To view the roles defined in the current database
To view the fixed database roles defined in the current database
To view the fixed server roles