1. List the users in the database.

Use Database

SELECT name, type_desc FROM sys.database_principals

Filter out what ever you need like

where type_desc = 'sql_user'

OR type_desc = 'windows_user'

2. List the logins and passwords.

Create the sp from method 3 in the 918992 KB.

Run sp_help_revlogin

3. Match your users from 1. with logins in 2.

Anybody got a more automated procedure for this?