use tempdb
go
exec sp_MSforeachdb 
	@command1 ='USE ?; INSERT tempdb..temp1 select db_name(), a.name, b.loginname from sysusers a left outer join master..syslogins b on b.sid = a.sid where a.sid is not null', 
	@replacechar = '?', 
	@precommand = 'if exists (select * from dbo.sysobjects where id = object_id(N''tempdb..temp1'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) DROP TABLE tempdb..temp1 
	    CREATE TABLE tempdb..temp1(dbname varchar(50), useraname varchar(50), loginname varchar(50))', 
	@postcommand = 'SELECT * FROM tempdb..temp1' 

CREATE TABLE #temp1(dbname varchar( 50 ), useraname varchar( 50 ), loginname varchar( 50 ))
declare @lastdb varchar( 50 )
set @lastdb = ''
while exists(select * from master..sysdatabases where name > @lastdb)
begin
	select @lastdb = (select top 1name from master..sysdatabases where name > @lastdb)
	exec('USE '+@lastdb+'; INSERT #temp1 select db_name(), a.name, b.loginname from sysusers a left outer join master..syslogins b on b.sid = a.sid where a.sid is not null')
end
select * from #temp1
drop table #temp1