USE [dbname]
GO
SET NOCOUNT ON
DECLARE @tabname sysname
DECLARE @sql nvarchar(max)
DECLARE @rows int
DECLARE table_cur CURSOR FAST_FORWARD FOR
SELECT name
FROM sysobjects
WHERE type = ‘U’
CREATE TABLE #results_tmp ( tabname sysname, cnt int )
OPEN table_cur
FETCH table_cur INTO @tabname
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = ‘INSERT INTO #results_tmp SELECT ”’ + @tabname + ”’, count(1) FROM ‘ + @tabname
EXEC sp_executesql @sql
FETCH table_cur INTO @tabname
END
CLOSE table_cur
DEALLOCATE table_cur
SELECT cnt, tabname FROM #results_tmp ORDER BY cnt DESC
DROP TABLE #results_tmp
GO