Try Like this in Your SP If You Know all the Database Names.

select t.name, i.name
from DatabaseName1.sys.tables t, DatabaseName1.sys.indexes i
where i.object_id = t.object_id
union
select t.name, i.name
from DatabaseName2.sys.tables t, DatabaseName2.sys.indexes i
where i.object_id = t.object_id

Regards Senthil Raja.J

modified on Thursday, December 30, 2010 4:34 AM