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

Printed 2014/10/21 12:46PM

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.