Issuing an index metadata script that I developed, but running into an error.
The SP’s name is sp_helpindexinfo and it is available here.
Msg 2767, Level 16, State 1, Line 1 Could not locate statistics ' ' in the system catalogs.
Trace the error back to a code written by yours truly.
Code – Original
Here is the original code
DBCC SHOW_STATISTICS ( '[dbo].[gl_detail]', ' ' ) WITH NO_INFOMSGS , DENSITY_VECTOR
Please revise your code to skip over heaps and check actual indexes or statistics.
To see which statistics exists
EXEC sp_helpstats @objname = '[LTEDRKV].[callLog]'
- Traced the problem back to trying to find statistics on an Heap
As always, the problem is mine.