DECLARE @tblROWCOUNT TABLE

(

"Db name" VARCHAR(1000),

"Table Name" VARCHAR(400),

"Row Count" BIGINT

)

DECLARE @SQL NVARCHAR(MAX)

SELECT @SQL = 'SELECT ''?'' ,o.name, i.rowcnt FROM ?.sys.sysobjects o, ?.sys.sysindexes'

+' i WHERE i.id = o.id AND indid IN(0,1) AND xtype = ''u'''

+'AND o.name <> ''sysdiagrams'' AND i.rowcnt > 0 ORDER BY i.rowcnt DESC'

INSERT INTO @tblROWCOUNT

EXEC Sp_msforeachdb @SQL

select * from @tblROWCOUNT