DECLARE @LOGINNAME VARCHAR(100)
DECLARE @CHANGECOMMAND VARCHAR(100)
DECLARE USERCURSOR CURSOR FOR
SELECT name
FROM sysusers
WHERE name not in
( 'public', 'dbo', 'guest', 'sys',
'Information_schema', 'db_owner', 'db_accessadmin',
'db_securityadmin', 'db_ddladmin', 'db_backupoperator',
'db_datareader', 'db_datawriter', 'db_denydatareader',
'db_denydatawriter'
)
OPEN USERCURSOR FETCH NEXT FROM USERCURSOR INTO @LOGINNAME
WHILE @@FETCH_STATUS=0
BEGIN
SELECT @CHANGECOMMAND = 'exec sp_change_users_login ''Auto_Fix'', ''' +@LOGINNAME + ''''
PRINT 'Executing the command '+@CHANGECOMMAND
EXEC (@CHANGECOMMAND )
FETCH NEXT FROM USERCURSOR INTO @LOGINNAME
END
CLOSE USERCURSOR
DEALLOCATE USERCURSOR
