this script worked in my DB

DECLARE @login nvarchar(50)

DECLARE logins_cursor CURSOR FOR

select master..syslogins.name as login_name

from master..syslogins WHERE master..syslogins.name<>'BUILTIN\Administrators'

OPEN logins_cursor FETCH NEXT FROM logins_cursor INTO @login

WHILE @@FETCH_STATUS = 0 BEGIN EXEC dbo.sp_change_users_login 'Auto_Fix' , @login FETCH NEXT FROM logins_cursor INTO @login END

CLOSE logins_cursor DEALLOCATE logins_cursor GO

select master..syslogins.name as login_name, sysusers.name as user_name from master..syslogins LEFT OUTER JOIN sysusers on master..syslogins.suid = sysusers.suid

--NOTE: use-> master..syslogins.sid = sysusers.sid in sql2000

this script worked in my DB

DECLARE @login nvarchar(50) DECLARE logins_cursor CURSOR FOR select master..syslogins.name as login_name from master..syslogins WHERE master..syslogins.name<>'BUILTIN\Administrators' OPEN logins_cursor FETCH NEXT FROM logins_cursor INTO @login WHILE @@FETCH_STATUS = 0 BEGIN EXEC dbo.sp_change_users_login 'Auto_Fix' , @login FETCH NEXT FROM logins_cursor INTO @login END CLOSE logins_cursor DEALLOCATE logins_cursor GO select master..syslogins.name as login_name, sysusers.name as user_name from master..syslogins LEFT OUTER JOIN sysusers on master..syslogins.suid = sysusers.suid 

--NOTE: use-> master..syslogins.sid = sysusers.sid in sql2000