On Index Fragmentation, right click to “generate a defragmentation script”. If the table is in a schema other than dbo the script generated works. The script needs to include the schema.
If the schema is not in the script the following error appears:
Error:-
Msg 1088, Level 16, State 9, Line 1
Cannot find the object "performance_counter_values" because it does not exist or you do not have permissions.
WORKAROUND
None
STATUS:
Issue fixed in the current release of Spotlight on SQL Server Enterprise. Latest version of Spotlight can be downloaded from here.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center