Microsoft SQL Get Number of Rows from All Tables

Below is a quick and easy method to retrieve number of rows / records from all tables in a database. The below code snippet is tested on Microsoft SQL Server 2005.

SET NOCOUNT ON
IF IsNull(object_id('tempdb..#temTable'),0)<>0 DROP TABLE #temTable
CREATE TABLE #temTable (
    Name sysname,
    Rows INT,
    Reserved sysname,
    Data sysname,
    IndexSize sysname,
    UnUsed sysName
)
INSERT INTO #temTable
    EXEC sp_msForEachtable " sp_SpaceUsed '?' "

SELECT Name, Rows
FROM #temTable
ORDER BY Name

IF IsNull(object_id('tempdb..#temTable'),0)<>0 DROP TABLE #temTable