select 
o.name AS Table_Name,
i.index_id, i.type as i_type, p.rows,
a.total_pages, a.used_pages, a.data_pages, a.type alloc_type
from sys.objects o
inner join sys.indexes i on o.object_id = i.object_id
inner join sys.partitions as p on i.object_id = p.object_id and i.index_id = p.index_id  
inner join sys.allocation_units as a on p.partition_id = a.container_id 
where o.is_ms_shipped = 0  and o.name= 'AlertasUtilizadorLog'
order by o.name, i.type

exec sp_spaceused 'AlertasUtilizadorLog'

Table_Name		index_id	i_type	rows	        total_pages	        used_pages	        data_pages	alloc_type
AlertasUtilizadorLog	0		0		319		57			54			53			1
AlertasUtilizadorLog	0		0		319		209			208			0			2
AlertasUtilizadorLog	2		2		319		4			4			2			1

name	                        rows	        reserved	data	        index_size	unused
AlertasUtilizadorLog	319        	2160 KB	2088 KB	40 KB	        32 KB