Hello Willie,

you're right, the result from sp_spaceused might differ from the query, since the query itself doesn't add xml indexes or fulltext indexes for the given table, in contrast to...

After putting together the previous query, I came along this undocumented sp:

sp_MSIndexSpace tablename

which also returns the sizes for each single index. Just in case anyone's looking for that...

While trying to find more about sizes of specific indexes, unlike the sum of used space as returned with sp_spaceused, I changed the queries used by sp_spaceused a bit...