declare cursor_insert cursor for select [name] from sysdatabases
declare @i varchar(100)
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec('select * from '+@i+'..sysobjects where xtype=''U'' and status>0')
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
1:
use master
go
select [name] from sysdatabases
2:
declare @database varchar(20)
set @database = 'master'
Exec('Select * from ' + @database+'..sysobjects where xtype = ''U'' ')