orphaned_users_fix_2005.sql

-- since MSSQL 2008 use
-- ALTER USER OrphanUser WITH LOGIN = correctedLoginName;

DECLARE @uname varchar(30) 
DECLARE curs1 CURSOR FOR 
  SELECT name
    FROM sysusers
    WHERE name <> 'dbo' AND issqluser = 1 AND hasdbaccess = 1
    ORDER BY name
OPEN curs1 
FETCH NEXT
  FROM curs1
  INTO @uname 
  WHILE @@FETCH_STATUS = 0 
BEGIN 
  IF (@uname IS NOT NULL) AND (@uname <> 'guest') 
    BEGIN 
      PRINT @uname 
      EXECUTE sp_change_users_login Auto_Fix, @uname, NULL, 'autopass' 
    END 
    FETCH NEXT
      FROM curs1
      INTO @uname 
END
CLOSE curs1
DEALLOCATE curs1