http://www.sqlservercentral.com/blogs/thesqlprocom-ayman-el-ghazali/2012/07/30/sql-server-orphanage-using-sp_change_users_login-to-find-and-fix-all-orphaned-sql-users/
Printed 2013/05/21 08:28PM
SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy the results of the query into a new query window then execute them. Make sure you keep the spacing and the quotes as they are so that the Dynamic SQL generated is free of Syntax [...]
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.