Binaryworld - Get table size and number of records for all tables in the specified d ... [ SQL Server -> Stored Procedure ]

/*
This stored procedure can be used to get the size of all users tables
in the particular database with the number of their rows.
You should simply pass the database name, as in the example below
(if the database name was not specified, the current database will be used):

EXEC GetAlltblRowsSize 'pubs'
*/

IF OBJECT_ID('GetAlltblRowsSize') IS NOT NULL DROP PROC GetAlltblRowsSize
GO

CREATE PROCEDURE GetAlltblRowsSize (
@dbname sysname = null
)
AS
DECLARE @execstr nvarchar(255)
SET NOCOUNT ON
IF @dbname IS NULL SELECT @dbname = DB_NAME()
SELECT @execstr = 'EXEC ' + @dbname + '..sp_MSforeachtable @command1="sp_spaceused ''?''"'
EXEC(@execstr)
GO