数据库的问题

[New919]

怎么把一台SQLSERVER服务器里面所有的数据库查出来？
怎么把每一个数据库里面的用户表查出来？
高手帮忙～

[vivianfdlpw]

exec sp_msforeachtable 'print ''?'''

or

declare @cursor cursor
,@name varchar(20)
set @cursor=cursor for select name from sysobjects where xtype='U'
open @cursor
fetch next from @cursor into @name

while @@fetch_status=0
begin
print @name
fetch next from @cursor into @name
end

close @cursor
deallocate @cursor

[点点星灯]

exec sp_MSforeachdb N'use [?]select dbname=db_name(),username=user_name()'