Fix Orphaned SQL Server Database Users

By Beej

Good reference

Quick examples:

sp_change_users_login 'report' -- this shows the list of orphaned users in the current database
sp_change_users_login 'update_one', 'iTRAAC_User', 'iTRAAC_User' -- this is how you remap one
Tags: Database
Share: Twitter Facebook LinkedIn