Orphans users

> Find list of the Orphans in the database

                                    sp_change_users_login 'report'

> Fix them Automatically in real fast :)

                                    sp_change_users_login 'auto_fix','loginName'
If it still not fix yet, the following may helpful..

> You can create newLogin same as the 'OrphonUser' which by running the report..Then run the following
                                    exec sp_change_users_login 'update_one' , 'OrphonUser', 'NewLogin';