Getting error:
Diagnostic Server - Spotlight Statistics Repository
Repository error [Maintenance Error]: Running maintenance on the Spotlight Statistics Repository failed : CONDITIONAL failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.
This happens when user create a custom trigger which conflict with Spotlight Statistics Repository and Playback databases maintenance build-in script.
WORKAROUND 1:
Put back to default "out of the box" Repository and playback database maintenance.
WORKAROUND 2: