SSMS table properties show an exception for Index space on every table 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.