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 2014/11/24 06:56AM

SQL Server Orphanage – Using sp_change_users_login to find and fix all orphaned SQL users

By TheSQLPro.com, 2012/07/30

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.