Return
-
Title
Spotlight informational warnings for SQL server connection: " Message: Incorrect syntax" -
Description
Spotlight is throwing below informational warnings for one of SQL server connection (SQL 2005 & OS Windows 2003 STD). There are no databases with 2000 compatibility mode.
"Information Monitored Server - SQL Server Collection Execution Failure 4/11/2017 5:45:28 AM Collection 'Database List' failed : Collection 'Files' failed : Collection 'Files (protected)' failed : Error 50000, Level 15, State 1, Procedure -, Line 122, Message: Error 102, Level 15, State 1, Procedure -, Line 9, Message: Incorrect syntax near '('. [50000] Spotlight on SQL Server Version: 11.7.0.8250 Diagnostic Server Scripts Version: 26.1.0.8250"
-
Resolution
WORKAROUND:Place the attached file in below path and replace existing file:C:\Program Files\Quest Software\Diagnostic Server\agent\conf\package\sqlserver_spotlight\2005\STATUS:Waiting for fix to be released in a future version of Spotlight on SQL Server Enterprise. -
Defect ID
DS-748 -
Attachments