SSMS table properties show an exception for Index space on every table

by Metaphor   Last Updated August 18, 2018 09:06 AM

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:

Property accessor 'IndexSpace

Answers 2

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.

Tara Kizer
Tara Kizer
August 05, 2016 17:05 PM

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.

But indeed, sp_spaceused should work without the extra permissions. Use with

sp_spaceused N'database_name.schema_name.table_name'
August 18, 2018 08:56 AM

Related Questions

SQL agent jobs hung state (SSIS jobs hung)

Updated March 19, 2017 19:06 PM

creating index on big table(s)

Updated September 03, 2018 18:06 PM