MS SQL Get the row counts of all tables in current database

GetDatabaseRowCounts.sql

DECLARE @sql VARCHAR(255) 
SET @sql = 'DBCC UPDATEUSAGE ("' + DB_NAME() + '")' 
EXEC(@sql) 

CREATE TABLE #Tables (tableName VARCHAR(255), tableRows INT) 
     
INSERT #Tables
  EXEC sp_msForEachTable 
    'SELECT PARSENAME(''?'', 1), 
    COUNT(*) FROM ?' 
 
SELECT  
  tableName AS 'Table', 
  tableRows AS 'Row Count'
FROM #Tables
ORDER BY tableRows DESC 
 
SELECT SUM(tableRows) AS 'Total Row Count' 
FROM #Tables

DROP TABLE #Tables