All tables' name with record count - SQL Server

CREATE TABLE #Table_Count
	(
	TableName	VARCHAR(MAX),
	RecordCount	BIGINT
	)
GO
INSERT #Table_Count
EXEC SP_MsForEachTable 'SELECT ''?'', COUNT(1) FROM ?'
GO
SELECT * FROM #Table_Count WHERE RecordCount > 0 ORDER BY RecordCount DESC 
GO
DROP TABLE #Table_Count