1. Copy the script over to you SQL Query Window
2.Replace the name of the database, that is, '<databasename>' with the name of the database to run against
3. Execute the script to view the resultset displaying that database's users and thier associated database roles
Note: The script works on SQl Server 2005, and has not been tested against SQL Server 2008 yet.