#title 복원후 SID 동기화
{{{
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
}}}