Sql – Sync SQL Logins utility on 2005/2008

sql-serversql-server-2005

Anyone point my at a utility for syncing sql server logins after restoring a database to a different server?

I know I can do it with scripts, but I've been using a wonderful little utility – 'Db Maint Sync SQL Logins' (http://www.dbmaint.com/SyncSqlLogins.asp) to do it on sql server 2000 which unfortunately doesn't support 2005 and I'm loath to go back to actually thinking 🙂

Best Solution

sp_change_users_login with the Update_One action can map a login in a database to a user on a new server.