Fixing orphaned SQL user accounts

Ever refresh/restore a database only to find out your database logins don't match up with the database user accounts? I run the following query to simultaneously identify any database user permissions that aren't mapped to current database logins and also synch up the passwords to the appropriate logins. Copying/pasting the output to a new query window should get permissions back the way they should be (assuming you want to set the password to "opensezME!": select 'sp_change_users_login ''auto_fix'', [' + name + '], NULL, ''opensezME!''' from sysusers where issqluser = 1 and (sid is not null and sid <> 0x0) and (len(sid) <= 16) and suser_sname(sid) is null order by name