DECLARE @db_name sysname, @SQL nvarchar(max)

--

IF OBJECT_ID('tempdb..#Results') IS NOT NULL

DROP TABLE #Results;

IF OBJECT_ID('tempdb..#Databases') IS NOT NULL

DROP TABLE #Databases;

--

CREATE TABLE #Results (DatabaseName sysname, TableName NVARCHAR(128), crdate datetime);

CREATE TABLE #Databases (databaseName sysname);

--

INSERT INTO #Databases

SELECT name FROM sys.databases WHERE name NOT IN ('master', 'tempdb', 'msdb', 'model');

WHILE (SELECT COUNT(*) FROM #Databases) > 0

BEGIN

SET @db_name = (SELECT TOP 1 databaseName FROM #Databases);

SET @SQL = 'USE ['+@db_name+'];

INSERT INTO #Results Select '''+@db_name+''' as [dbname], name as [tblname], crdate from sysobjects'

--

EXEC (@SQL)

--

DELETE #Databases

WHERE databaseName = @db_name

END;

--

SELECT * from #Results;

just another cursor rewrite for fun..