3

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

4
  • That's a .NET error...I've seen it it sometimes using LINQ when writing C#. If it's showing up in SSMS, it might mean there's a bug. I'd say contact Microsoft Support for this one.
    – Haris Khan
    Aug 5, 2016 at 16:42
  • This can also be caused by "add-ins" which are not supported with SSMS. Aug 5, 2016 at 17:14
  • It isn't add-ins as the 2016 SSMS is "fresh out of the box".
    – Metaphor
    Aug 5, 2016 at 17:33
  • Run a repair on SSMS, for 2016 try applying latest version "13.0.15600.2". Have you applied any of the updates for VS since you installed SSMS? I have had that cause issues and had to repair SSMS.
    – user507
    Aug 7, 2016 at 7:28

2 Answers 2

4

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.

2
  • 1
    Getting the data is not a problem - sp_spaceused will give me what I need. I've just never seen that issue before. What's more, I asked my co-worker with the same setup to get the props and he had no problem.
    – Metaphor
    Aug 5, 2016 at 17:31
  • So he has the same exact SSMS build? Maybe a .NET build issue then?
    – Tara Kizer
    Aug 5, 2016 at 17:33
1

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'
2
  • For anyone who downvotes, please explain what's wrong with this answer. I'm new to this site and can use some help!
    – PHPirate
    Aug 20, 2018 at 12:40
  • 1
    Not sure why this answer received a down vote. I tried it and connecting with db_owner credentials fixed the issue for me (same machine).
    – c31983
    Aug 7, 2019 at 14:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.