http://www.sqlservercentral.com/blogs/databaseexpertisecom/2010/08/31/how-to-fix-orphaned-users/

Printed 2014/09/22 08:39PM

How to fix Orphaned Users

By Justin H-Davies, 2010/08/31

 To view if there are any orphaned users, run this query against the DB;

 sp_change_users_login ‘report’

To fix;

 sp_change_users_login ‘update_one’, ‘dbUser’, ‘sqlLogin’


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.