Printed 2017/08/22 01:08PM

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

By, 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-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.