--转载时请保留下面,以供大家加我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