How to fix outdated names of Windows logins?
I had a problem when testing a code from a production server to development (pre-production) server, this was used by using a sync. of logins. Environment is similar on each other SQL Server 2005 on Windows 2003 server. Only change was a domain name, I was aware that using SP_CHANGE_USERS_LOGIN statement the out-of-sync logins can be fixed, bear in mind sp_change_users_login cannot be used with a SQL Server login created from a Windows principal.
Bingo! Laurentiu's blog post was my saviour.