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?