When getting table properties from a SQL 2014 server (12.0.4449) using SSMS 2014 (12.0.4100) or 2016 (13.0.15600) on any database or table I get the following text for the "Index space" property on the Storage tab:
An exception occurred while executing a Transact-SQL statement or batch.
This is the error:
Like Haris commented, it's likely an SSMS bug that Microsoft will have to resolve. But you should be able to run a trace or an Extended Event session to capture the TSQL that SSMS is using to get the data that you are after. Capture the TSQL and then run that in a query window. Or use the query from marc_s.
If possible, try to have your permissions level upgraded to
db_owner, it can solve the issue.
That also explains why a co-worker with the same setup would be able to see the property but you don't.
sp_spaceused should work without the extra permissions. Use with