SQL Script to Get Row Count of All Tables in Database

count-tables.sql

-- Method 1:

sp_msforeachtable "SELECT '?', COUNT(*) FROM ?"

-- Method 2: (nicer, more details)

CREATE TABLE #TempTable
(
    tableName varchar(100),
    numberofRows varchar(100),
    reservedSize varchar(50),
    dataSize varchar(50),
    indexSize varchar(50),
    unusedSize varchar(50)
)
GO

EXEC sp_msforeachtable "INSERT #TempTable EXEC sp_spaceused '?'"
GO

SELECT * FROM #TempTable

DROP TABLE #TempTable
GO