修复所有数据库的登录用户(用于数据库还原后原数据库用户无法登录及权限)

--转载时请保留下面,以供大家加我MSN,增强交流,共同学习.
--姜庭华  msn: jaimejth@live.cn
--博客:http://blog.csdn.net/jaimejth
declare @dbname varchar(100),@exec_sql varchar(4000)
declare cursor_db cursor for select name from master..sysdatabases where dbid>6
open cursor_db
fetch next from cursor_db into @dbname
while @@fetch_status=0
begin
    set @exec_sql='declare @user varchar(100),@t varchar(1000)
    declare cursor_user cursor for select name from ['+@dbname+']..sysusers where isaliased = 0 and status<>0 and name<>''dbo''
 open cursor_user
 fetch next from cursor_user into @user
 while @@fetch_status=0
 begin
    set @t=''use ['+@dbname+'] EXEC sp_change_users_login ''''Auto_Fix'''', ''+@user+'', NULL, '''''''' ''
    execute(@t)
    fetch next from cursor_user into @user
 end
 close cursor_user
 deallocate cursor_user'
    execute(@exec_sql)

 fetch next from cursor_db into @dbname
end
close cursor_db
deallocate cursor_db