Check Used Table Space for User Defined Tables

DECLARE
@TABLENM SYSNAME,
@CNT INT,
@TOPN INT
DECLARE TABLE_SPACE CURSOR FAST_FORWARD
FOR 
 SELECT
 NAME
 FROM SYSOBJECTS
 WHERE XTYPE = 'U'
SELECT @CNT = 0, @TOPN = 0
CREATE TABLE #TMPUSAGE
 (
 NAME SYSNAME,
 ROWS INT,
 RESERVED VARCHAR(20),
 DATA VARCHAR(20),
 INDEX_SIZE VARCHAR(20),
 UNUSED VARCHAR(20)
 )
OPEN TABLE_SPACE
FETCH NEXT FROM TABLE_SPACE INTO @TABLENM
WHILE @@FETCH_STATUS = 0 AND @CNT <= @TOPN
BEGIN
INSERT INTO #TMPUSAGE 
EXEC SP_SPACEUSED @TABLENM, 'TRUE'
 IF
@TOPN <> 0
SELECT @CNT = @CNT +1
FETCH NEXT FROM TABLE_SPACE INTO @TABLENM
 END
CLOSE TABLE_SPACE
DEALLOCATE TABLE_SPACE
SELECT 
 *
FROM 
#TMPUSAGE 
ORDER BY 
CONVERT(INT,LEFT(RESERVED, LEN(RESERVED)- 3)) DESC

IF (SELECT OBJECT_ID('TEMPDB..#TMPUSAGE') ) IS NOT NULL
DROP TABLE #TMPUSAGE