This cursorless loop was a new trick for me, and very appreciated. 

WHERE TableName>@TableName

IF @TableName IS NOT NULL
BEGIN
INSERT INTO #T
exec sp_dba_spaceused @TableName
END
END

This trick eliminates loop as well as cursor. 

1) generate a script

select 'insert into #t exec sp_dba_spaceused ' + name
from sysobjects where type = 'u'
order by 1

2) run the script

When writing an automated process, I usually use the loop rather than this "select literal with select set to generate a script" trick, but it is possible to automate running the script that the select statement generates.

USE Master
GO
CREATE PROC dbo.sp_DBA_spaceused_AllTables2
	@updateusage varchar(5)='false'
AS
SET NOCOUNT ON

IF @updateusage IS NOT NULL
	BEGIN
		-- Allow for case sensitivity
		SET @updateusage=LOWER(@updateusage)
		IF @updateusage NOT IN ('true','false')
			BEGIN
				RAISERROR(15143,-1,-1,@updateusage)
				RETURN(1)
			END
	END

-- Retrieve the current page size for the OS
DECLARE @KB DEC(15)
SELECT @KB = low/1024.0
FROM master.dbo.spt_values
WHERE number=1
AND type='E'

SELECT
	MAX(DB_NAME()) AS DatabaseName ,
	MAX(GETDATE()) AS DateSampled ,
	U.Name+'.'+O.Name AS TableName ,
	MAX(CASE WHEN I.Indid<2 THEN I.rows ELSE 0 END) AS rows,
	SUM(CASE WHEN I.Indid IN(0,1,255) THEN I.reserved ELSE 0 END) * @KB AS reserved ,
	SUM(CASE WHEN I.indid<2 THEN I.dpages ELSE 0 END
	+ CASE WHEN I.indid=255 THEN used ELSE 0 END) * @KB AS data ,
	SUM(CASE WHEN I.indid<2 THEN used-dpages ELSE 0 END) * @KB AS index_size ,
	SUM(CASE WHEN I.indid IN(0,1,255) THEN I.reserved - I.used ELSE 0 END) *@KB AS Unused

FROM	dbo.sysobjects AS O
	INNER JOIN dbo.sysindexes AS I ON O.id = I.id
	INNER JOIN dbo.sysusers AS U ON O.uid = U.uid
GROUP BY U.Name+'.'+O.Name 
GO

Thanks, David - and I agree, XML in a relational database might not be the best choice in all cases. But that discussion aside - what I was really hoping to find out is how to include the XML indices in your code snippet, e.g. how do I tweak your code so that the XML indices (which use up A LOT of space!) are also included? Any ideas? Anyone?

Thanks!
Marc