Hi,

Try this :

CREATE TABLE #t(d SYSNAME, t SYSNAME);

EXEC sp_msForEachDB 'INSERT #t SELECT ''?'', TABLE_NAME

FROM [?].INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE=''BASE TABLE'';';

SELECT * FROM #t ORDER BY d,t;

DROP TABLE #t;

Thanks,

Oana.